Input masks

[tinab]

What mask do I enter to make the user have to enter a telephone number
with the area code then a dash then the three numbers then a dash and
then four numbers. The dashes must be entered by the user.

 

[Wayne Morgan]

Access will make this one itself. Click the ... button to the right of the
Input Mask box in the Properties sheet for the control. The button will show
up when you click into the Input Mask box.

 

[John Vinson]

What mask do I enter to make the user have to enter a telephone number
with the area code then a dash then the three numbers then a dash and
then four numbers. The dashes must be entered by the user.

Well... take a look at the online help for Input Masks; it explains
what characters do what! 0 means the user must enter a digit; - means
that a hyphen is required (and it will be filled in automatically if
the user doesn't type it).

Try

000-000-0000;0;_

The 0 means "store the hyphens in the field", the _ means to use an
underscore as a placemarker.