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 want to help you work in your business, so you can work on your business. I want to help you achieve your goals and help you have a successful small business journey. I understand that keeping up with the latest technology and cloud based computer trends can be difficult, when you’re running your day to day business. But, it is crucial that you keep up with the technology and best understand your options, in order to thrive in this new era of online business. I can help you discover the right software and tools for your business, train your team on how to use them, and mentor you to best serve and delight your customers. My certifications include: QuickBooks ProAdvisor, Microsoft Office Specialist Master, and OntraPort Certified Consultant. Please contact me on my new website at
This entry was posted in Access and tagged , . Bookmark the permalink.

17 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!

  4. Nidhi Mittal says:

    when I want to allow only letter not degits L des not work, it replace all letters with L

  5. Steph says:

    Hi Steve, I was assigned to create an input mask for a telephone number using only the last seven digits (excluding the area code), is there a way to edit the input mask so the parenthesis for the area code do not show up? Thanks!

  6. Ravindu says:

    how to enter ww-AAA-1111

  7. Laura Sam says:

    how the input mask will be look like for emails ??

  8. Steve Chase says:

    Laura, my earlier comment would not go in the input mask because emails vary so much. Instead it is recommended to use data validation instead.

  9. Helen says:

    Hi Steve, I would like to enter numbers 00/00/00/00.
    Separation must be /
    What would be the correct mask for this. Please.

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s