How to Add A Telephone Mask in an Access Table

0
18337

Add Telephone Mask to Access Table

This post is a continuation of an Access How-to Series that I’m working on, the last article that I posted walked you through the creation of a table in Access. This how-to will address the application of masks to fields in your table, specifically the telephone mask. The Telephone Mask can be very useful if you would like to store telephone numbers in a table in your database, not only does it format the field as a telephone number would be displayed, but it also helps with the entry of the information. If you have any comments or questions, please post them below.

Note: I used Access 2000 for this tutorial

Add Telephone Mask to Access Table

1. Open your Access database, click on the the table you wish to modify and click the Design button

Note: I will be using the same table I created in the first Access tutorial, tbl_employee

Add Telephone Mask to Access Table

2. Enter a name for the telephone field in the Field Name column, leave Text as the Data Type, and add a Description that can be used for future reference. In the Field Properties section make sure the General tab is selected, click on the button with the 3 dots next to the Input Mask

Add Telephone Mask to Access Table

3. Before you continue you will be prompted to save the changes you have made to your table, click Yes to save those changes.


Add Telephone Mask to Access Table

4. Select the Phone Number mask from the Input Mask list, click Next

Add Telephone Mask to Access Table

5. Unless you want to specify a different format, leave the default settings and click Next

Add Telephone Mask to Access Table

6. You have the option of choosing how the data will be stored with the mask, with or without symbols (I chose the "With the symbols…" option), make your selection and click Next

Add Telephone Mask to Access Table

7. Click Finish when you’re done

Add Telephone Mask to Access Table

8. Click on the Save icon to save your changes. Open the table and enter a telephone number in the Telephone Number field you just created. The telephone number you enter should be displayed with the following format (123) 555-5555

Access Icon via benjigarner