Format Telephone Numbers

[jacger]

I am a fairly new user to program. Moving over from Access. I have not found a way to mask or format a phone number automatically. Would like to type just numbers and have mask of (xxx) xxx-xxxx fill for me. How can I do this.

[LiveOak]

The most typical method is to use two fields:

Phone# (text)

Phone#Formatted(calculation, text) =

"(" & Left(Phone#, 3) & ")" & Middle(Phone#,4,3) & "-" & Middle(Phone#,7,4)

This calculation assumes the user won't try to enter formatting into the entry field. More complex calculations can be create to handle this.

To use these two fields on a layout. Put the Phone# field under and hidden by the Phone#Formatted field. Assign a button to the top field (Phone#Formatted) with the step Go to field[Phone#]. This has the effect of allowing the user to enter into the hidden unformatted field and view the top formatted field. -bd