Area Code

[storlogic]

Hello

I'm looking for a way to omit the area code when a phone field is displayed
in a form. I can't figure out how to do this with an input mask. Is it
possible to do this in an input mask? If not, how would I omit it?

The data in the tabel where this information is coming from does have an
area code included in the "phone" field. There is over 5000 records so it's
not an option to change the field so that the first three digits (area code)
become it's own field.

Any help would be appreciated.

Cheers,
StorLogic

 

[Damon Heron]

I am guessing that the area codes in the table are all the same? Otherwise,
why would you not want the option to enter them? So, lets say your area
code is 415, use this:

"(415) "999\-9999

Damon

 

[storlogic]

Hello Damon

There are different area codes. For numerous reasons, we don't need the
area code displayed.

 

[John Spencer]

You can't control that with an input mask or a format.

If you only need to display (not edit) you can use

Right([Telephone],8) to get the 8 characters on the right.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Gina Whipp]

storlogic,

You can create your own mask. Go into a table and click the Elipse button
(button with 3 dots) on the Input line. When the window opens click Edit
List and then the >* (New button) and add your new mask. Once added click
Cancel. Now that Inout Mask will be available for you to use.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm