Access Input Mask Cheat Sheet

Use an Input Mask to control data entry in an Access database. For example, you can force users to enters  a phone number with an area code or an employee identification code with 2 letters followed by 3 numbers.

Below is a cheat sheet for Access input masks.

Access cheat sheet input mask

(000)-000-0000 will force the user to enter a phone number with an area code.

(999)000-0000! will force to user to enter a 7 digit phone number but is optional for the area code. The exclamation mark causes the input mask read the numbers from left to right.

LL-000 will force the user to enter 2 letters followed by 3 numbers.

>L<??????????????? will make the first letter capitalized and the following letters lower case.

Check out my Access keyboard shortcuts guide or other Access blog posts by clicking on the Access link on the right sidebar.


About Steve Chase

I'm a proud husband and dad to 4 boys! Microsoft Certified Trainer and Boy Scout Leader are some of things I call myself. The Cincinnati Reds are my favorite team! When not outdoors, I enjoy working with documents in Microsoft Office, QuickBooks, Visio and Photoshop. My wife, Erin, shares her awesome recipes on her blog at
This entry was posted in Access and tagged , . Bookmark the permalink.

6 Responses to Access Input Mask Cheat Sheet

  1. Madeline Case says:

    Thanks for sharing. Just passed my MOS Access 2010 certification exam. Now completed full cycle of the MOS 2010: Word, PPT, Excel, Outlook and of course Access.

  2. Where can I find the option to make a data entry such as “040416” change to “04/04/2016”?

  3. Jared says:

    This webpage really helped me study for my Final CAT High School Exam
    Thank you Steve!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s