Faculty/Staff Help Student Help About Computer Services    
   

Access Tip -  Simplify data entry with an input mask

It's much easier to enter phone numbers if you don't have to type the hyphens and parentheses. You can configure Access to enter those special characters for you by using the field's Input Mask.  

To create an input mask for a phone number field, follow these steps:

  1. Open the table in Design View, and select the Phone field.

  2. In the Field Properties window, click the Input Mask text box.

  3. Click the builder button to the right of the text box  .

  4. Click Next to select the suggested phone number mask.

  5. Click Next to select the suggested placeholder, and click Finish.

 Now, to enter a phone number, just move to the field, and type the numbers

.

 

 
Ouachita Baptist University • Computer Services
Cone Bottoms Hall 250 • 870.245.5567

online support form support@obu.edu www.obu.edu