Telephone Number Format

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

 

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

 

[Tony Toews]

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

 

[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 (e-mail address removed)

 

[GVaught]

Try using the Input Mask against the field when in design view of the table.