Input of phone numbers

M

mscertified

I want to force input of U.S. phone numbers in 999-999-9999 format. I will
store the numbers and the dashes. How do I create an input mask to enforce
this? The existing mask forces (999) 999-9999 which I don't want.

Thanks.
 
C

Chris

You should be able to just key the mask that you want without using the
wizard. I have a database where I use the mask 99-99999-99-9. This does not
store the dashes which IMHO provides more flexibility should you one day
decide to change how the numbers are displayed.
 
F

fredg

I want to force input of U.S. phone numbers in 999-999-9999 format. I will
store the numbers and the dashes. How do I create an input mask to enforce
this? The existing mask forces (999) 999-9999 which I don't want.

Thanks.

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

Klatuu

Chris is correct. Storing the dashes is not a good idea. It only takes up
disk space. You can always put the dashes back in when you display it to a
user.

Format([PhoneNbr], "999-999-9999")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top