phone number of area code

[yanliang]

I ran into a problem where I need to find those who did not enter an area code for phone numbers.
(626)421-3459 is correct
but some are ()421-2459, are the one I need to find.
how to find those who those.

 

[Gasman]

Try Mid(field,2,1)=")"

 

[namliam]

Like "()%"
left(field,2) = "()"
len(field) <= 10
Just to offer a few ideas

 

[Pat Hartman]

Look at your input mask. Is it set to store the separator characters or not?

To find the missing area codes, I would use the len() function.

Iif(len(yourphone)) <> 10 Then ''if the special characters are NOT stored
Iif(len(yourphone)) <>13 Then '' if the special characters are stored