Telephone Number Format

W

wmcrcc2002

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..
 
B

Byron

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..
 
T

Tony Toews

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
 
J

jim martin

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 [email protected]
 
Top