How do I do a default area code in Access 2003

's Computer Specifications

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.

's Computer Specifications

Try this --
Open the table in design view and set default to 505.
Set Input Mask to "(5"0"5)-"000\-0000

"Charee" wrote:

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

's Computer Specifications

In my haste I made a mistake. Use this instead of my earlier post --
Input Mask "("000")-"000\-0000
Default 505

"Charee" wrote:

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
For Outlook 2003 contacts, how do I set the default area code?	=?Utf-8?B?YXR0aXR1ZGU1NQ==?=	Microsoft Outlook Contacts	2	24th May 2006 11:50 PM
After the default printer has been changed by code in Access 2003, the application still directs a report to the former default printer.	Peanuts	Microsoft Access Forms	2	26th Feb 2006 06:32 AM
After the default printer has been changed by code in Access 2003, the application still directs a report to the former default printer.	Peanuts	Microsoft Access Reports	1	24th Feb 2006 02:34 PM
After the default printer has been changed by code in Access 2003, the application still directs a report to the former default printer.	i8mypnuts@yahoo.com	Microsoft Access Form Coding	1	24th Feb 2006 01:24 PM
Default area code	=?Utf-8?B?WmlwcHk=?=	Microsoft Outlook Discussion	1	1st Jul 2004 11:54 PM