Access Phone Number Input Mask

How do i make a phone number into an input mask?

Under Field Properties, click the Triple Dot button in the Input Mask property box. In the Input Mask Wizard, click Edit List. Click the New Record button. In Description, enter Alphanumeric Phone Number. In the Input Mask box, enter !(999) AAAAAAA. In the Sample Data box, enter (800) GoBirds.

How do i use the input mask symbols in access?

With the symbols in the mask: This will store the text you type in the field and the input mask symbols. For example, if you enter 5555555555 in a Phone field, Access will save the input mask symbols with the text you enter, so (555) 555-5555 would be saved. Without the symbols in the mask: This will store only the text you type in the field.

How do i create an alphanumeric phone number in access?

Follow these steps: Open the table in Design View. Click the Telephone Number field. Under Field Properties, click the Triple Dot button in the Input Mask property box. In the Input Mask Wizard, click Edit List. Click the New Record button. In Description, enter Alphanumeric Phone Number. In the Input Mask box, enter !(999) AAAAAAA.

What is an example of an input mask?

For example, the following specifies an input mask for a text box control used for entering a phone number. When you create an input mask, you can use special characters to require that certain data be entered (for example, the area code for a phone number) and that other data be optional (such as a telephone extension).