Format number field for Phone Number

[fmsteve]

I have a field for a phone number that I would like to be formatted for easy viewing. ie;

(111) 222-3333 without actually using those characters in the field as this field needs have JUST the digits.

The formatting would be for display purposes only while the data is JUST the ten digit phone number.

Any ideas?

TIA,

Steve

[MarkWilson]

Steve,

Your can find some phone custom functions at Brian Dunning's site. Use one of the functions in a calculation field, entry disabled, over the phone field.

[Lee Smith]

Take a look at Database Pros and search for Phone Format

Lee

[fmsteve]

Thanks, I will check that out.

What I have done for now is to use two fields. One contains just the ten digits the 2nd field is a calc field that does this:

"(" &

Left ( PhoneTestRaw ; 3) &

")" &

Middle ( PhoneTestRaw; 4; 3) &

"-" &

Middle ( PhoneTestRaw; 7; 4)

Does the function that you recommend utilize just one field? That would be preferred.

AGain, thanks for the SUPER FAST reply!!

Steve

[Lee Smith]

You can use the "Option" for the field, and use Auto Enter, be sure to Deselect the "Do not replace existing values in Field (if Any).

HTH

Lee