KeyPress Event: Disallow Characters in MS Access

In this Microsoft Access tutorial, I will show you how to enforce data entry rules for names, ensuring only capital letters A-Z are allowed in fields, without special characters or spaces. We'll utilize the key press event and VBA code to restrict unwanted characters, providing you with a robust solution for maintaining data integrity.

Sadie from Alpharetta, Georgia (a Platinum Member) asks: My client is very strict about how names are entered in our database. For the First Name and Last Name fields, they only want capital letters. No spaces, no apostrophes, no special characters, or numbers. Just A-Z and nothing else. Is there a way to enforce this in Microsoft Access? Can this be done with just an input mask, or do I need to use VBA?

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA
• If Then

Links

• Input Mask
• After Update
• Change Case
• ByRef v ByVal
• ASCII Chart
• Wikipedia
• Disable Copy Paste

Recommended Courses

• Search As You Type in Access Developer 8
• Search As You Type in Search Seminar
• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, input mask, capital letters only, key press event, VBA key ASCII, character validation, enforce data entry rules, ASCII uppercase range, Access form design, preventing invalid input, event handling, character filter, uppercase conversion, Access field validation