Validating telephone numbers

[rocky 123]

Hi there,

I want to validate a telephone number input field, but don't know wha
to use. Doing a length check allows erroneous such as letters to be i
the phone number. And doing a check of 'whole number' doesn't wor
either as different phone numbers have different lengths and most star
in zero.

Anybody got any ideas please?

Thanks,
rocky

 

[JE McGimpsey]

One way:

This is a simplistic example - you'll want different possible valid
formats:

Public Function ValidPhone(sIn As String) As Boolean
ValidPhone = (sIn Like "(###) ###-####") Or _
(sIn Like "###-###-####")
End Function