Access 2007

  • Thread starter Thread starter Bishop
  • Start date Start date
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?
 
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.
 
Back
Top