only Zeros in telephone number field check

[questionit]

Hi

I have a text field for telephone number.

It is set to take atleast 10 digit and maximum 15 digits

How can i write a condition that would alert us if the 11th to 15th digits are only 0 (zeros) or only 1(ones) , 2, 3, so on ??

Thanks

[questionit]

Hi

I have a text field for telephone number.

It is set to take atleast 10 digit and maximum 15 digits

How can i write a condition that would alert us if the 11th to 15th digits are only 0 (zeros) or only 1(ones) , 2, 3, so on ??

Thanks

Just to add that user can input 11, 12 , 13, 14 or 15 digits.
so if any number of digits after the 10th digit is '0'.. an alert should show

[Killer42]

I have a text field for telephone number.
It is set to take atleast 10 digit and maximum 15 digits
How can i write a condition that would alert us if the 11th to 15th digits are only 0 (zeros) or only 1(ones) , 2, 3, so on ??

Not sure I entirely understand what you're trying to achieve. But you might try a simple brute-force approach, something like this...

LastPart = Left$(strPhonenum,11)
Select Case LastPart
  ' Just list here all the combinations you want to disallow. Such as...
  Case "11111", "22222", "33333", "44444", _
       "55555", "66666", "77777", "88888", "99999", "00000"
    ' Do a dummy-spit.
End Select