 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / February 2008Input of phone numbers
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. 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. > 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. > 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;_  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail 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") SignatureDave Hargis, Microsoft Access MVP > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.