Telephone Number Field

[motiv8td1]

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]

Look at the Input Mask property.

 

[BrettStah]

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]

Thank you both, worked perfectly!!!

Joy