View Full Version : Telephone Number Field


motiv8td1
04-25-2007, 08:40 AM
I'm a total newbie in Access....is there a way to format a field in a table for a phone number so that when you put the info in it automatically puts the dashes in between the area code and such?

pbaldy
04-25-2007, 08:55 AM
Look at the Input Mask property.

BrettStah
04-25-2007, 08:57 AM
Here's an example of using the Format property to do it for a U.S. phone number:

@@@-@@-@@@@

You would use an input mask to restrict the type of characters that could be inputted (to prevent the use of letters, for example).

motiv8td1
04-25-2007, 09:03 AM
Thank you both, worked perfectly!!!

Joy:D