Telephone Number Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I set a specific column up to reflect a telephone format? e.g. (xxx) xxx-xxxx So that the user simply types 10 digits and it will properly format the numbers to reflect a telephone number..
 
Use the Input Mask property and select the Phone mask.
-----Original Message-----
How can I set a specific column up to reflect a
telephone format? e.g. (xxx) xxx-xxxx So that the user
simply types 10 digits and it will properly format the
numbers to reflect a telephone number..
 
wmcrcc2002 said:
How can I set a specific column up to reflect a telephone format? e.g. (xxx) xxx-xxxx So that the user simply types 10 digits and it will properly format the numbers to reflect a telephone number..

You will never have a phone number outside of North America? Or one
with an extension?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
i am trying to find out the same thing. i want my phone
number field that looks like this 999-999-9999 to look
like this 9999999999 in access 2002 it seems hard....
please email me if you learned how (e-mail address removed)
 
Back
Top