Verify Phone Number
For a start:
Function IsPhone(n) As Boolean
IsPhone = False
If Application.IsNumber(n) Then
If Len(n.Value) = 10 Then
IsPhone = True
End If
End If
End Function
--
Gary''s Student
"Striker" wrote:
~~~WOW, this accidenlty went to Access Newsgroup. Must not have been paying
attention this morning!!~~~~
Is there a method for verifying first if the data entered is a valid number,
then if it's a valid phone number? By Valid phone number I mean is it 10
digits without any formatting EXAMPLE ##########?
I think I can use IsNumeric for the first part, but can I pass a format to
IsNumeric, if so how?
Thank You
|