Phone Number Input Mask

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JamesJ - 01 Mar 2008 20:10 GMT

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

Had it once but lost it.

Thanks,
james

Reply to this Message

fredg - 01 Mar 2008 20:55 GMT

> What would I set the input mask for a phone number field:
> ###-###-####
[quoted text clipped - 3 lines]
> 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?

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

JamesJ - 01 Mar 2008 22:02 GMT

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

Thanks much,
James

>> What would I set the input mask for a phone number field:
>> ###-###-####
[quoted text clipped - 24 lines]
> dots that appears on that line to open the Input Mask Wizard and let
> the wizard create it for you?

Reply to this Message

Allen Browne - 02 Mar 2008 04:09 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I did but I wasn't sure about editing the mask.
> The first example with the hyphens worked fine.
>
> Thanks much,
> James

Reply to this Message