How do I do a default area code in Access 2003

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

Guest

I down loaded the contact templet for Access 2003 and I would like to change
the format on the phone number to (505)-000-0000 with the default area code
of 505. In Access 200 it was easy..now they are asking for a formula which I
do not know how to use.
 
Try this --
Open the table in design view and set default to 505.
Set Input Mask to "(5"0"5)-"000\-0000
 
In my haste I made a mistake. Use this instead of my earlier post --
Input Mask "("000")-"000\-0000
Default 505
 
You must log in or register to reply here.

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

Similar Threads

Defaul area code 2
Excel "Local" phone numbers in a list do not include area code. How to add? 2
how do I change area code in Contacts? 1
Default value for area code 1
Input Mask Default Value 3
Area Code 4
need to search phone numbers 2
Phone# Input mask with default 3

Back
Top