### Title

Help with a phone number field

### Post

I have created a data base and I have a field set up for phone number. How do I set the field so that if I enter 7135428288 it will display it as 713-542-8288 or (713)542-8288.

Thanks if you can help me.

Barry

Do you want to keep the value entered as pure numeric digits or could an auto-enter calculation provide the formatting after you exit the field?

This calculation will provide the formatting:

Let ( n = Filter ( Self ; 98765543210 ) ; "(" & Left ( n ; 3 ) & ")" & Middle ( n , 4, 3 ) & "-" Right ( n ; 4 ) )

Put this in an auto-entered calculation with "do not replace existing values..." cleared and you'll see the formatting added when you exit the field. A more sophisticated version of this calculation can check the number of digits entered and add a default area code if desired.

Put the same expression in a calculation field, but with the name of your field in place of "self" and you get one field for data entry where you just enter the digits and a second calculation field for displaying the formatted phone number.