Access 2007

B

Bishop

I am building a contact data base for my church. How do I get the phone field
to automatically format like this (xxx) xxx-xxxx when the numbers are typed
in the cell?
 
D

Daniel Pineault

In the form design view select the phone control and open the properties
dialog. Goto the Data tab and use the Input Mask to define the format you
wish to use. If you click on the ... to the right hand side on the property
you will get another dialog where there are predefined input mask or you can
define your own.

For instance, I use

!\(999") "000\-0000;0;_

to format my telephone controls, but you may wish a different format
depending on your exact needs. You can look up Input Mask in the help or
even on google to gets tons more information on the subject.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 

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

Top