Validate Email Addresses in Microsoft Access

In this video, we'll discuss why you shouldn't use an Input Mask for email addresses. Instead, I'll show you how to use a Validation Rule to catch most incorrect email addresses. 

Wade from San Francisco, California (a Platinum Member) asks: I just watched your video on Input Masks. It was very helpful. Thank you. Is there any way to set up an Input Mask for an email address? I've Googled a few things, but nothing seems to work. Thanks.

Members

Members will learn how a simple validation rule will catch the majority of bad email addresses, but not all. We will write a custom function in VBA to validate most possible email addresses using the rules from the majority of Internet mail servers.

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!

Validation Rule

Is Null Or ((Like "*[email protected]?*.?*") And (Not Like "*[ ,;]*"))

Suggested Course

• Access Beginner 3: https://599cd.com/ACB3

Links

• Input Masks: https://599cd.com/InputMask
• Validation Rules: https://599cd.com/ValidationRule
• Microsoft's Validation Rule: https://599cd.com/MSEMVALRUL
• Wildcards & Like: https://599cd.com/Like
• Input Masks of Varying Length: https://599cd.com/InputMaskVariable
• Table Level Validation: https://599cd.com/TLValidation
• Email Validity Rules: https://tinyurl.com/y97v8nbl
• Email Validity Rules: https://en.wikipedia.org/wiki/Email_address

Learn More FREE Access Beginner Level 1 Access Level 2 for $1.00 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources 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

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, input mask for email, input mask email address, How to Set an Input Mask for Email in Microsoft Access, How do you create an input mask for email in access, Email address input mask, email address validation, Email address input mask, Access Email Input mask, validation rule for email address in access, email validate, Email Address Verifier