Phone Number Input Mask

[JamesJ]

What would I set the input mask for a phone number field:
###-###-####

Had it once but lost it.

Thanks,
james

 

[fredg]

What would I set the input mask for a phone number field:
###-###-####

Had it once but lost it.

Thanks,
james

Do you wish th save the hyphens with the data in the table?
212-258-1234

!999\-000\-0000;0;_

If you only wish the hyphens to show during entry but not be saved
with the data:
2122581234

!999\-000\-0000;;_

Entry of the area code is optional.

Any reason why you didn't
1) just click in the Mask property line and press F1 and read the help
file?
Or...
2) Click in the Mask line and click on the little button with the 3
dots that appears on that line to open the Input Mask Wizard and let
the wizard create it for you?

 

[JamesJ]

I did but I wasn't sure about editing the mask.
The first example with the hyphens worked fine.

Thanks much,
James

 

[Allen Browne]

James, you might want to consider whether an input mask will cope with all
the phone numbers you could ever need to store.

It certainly won't hande some international numbers.