Channel: Computer Learning Zone

Category: Education

Tags: #tutorial#msaccesshow do you create an input mask for email in accesshow to set an input mask for email in microsoft accessemail validateinput mask for emailemail address input maskemail address validationaccess email input maskms access#microsoftaccess#howto#lessonvalidation rule for email address in accessinput mask email addressemail address verifier#trainingmicrosoft access#help#database#learnms access tutorial

Description: 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. Silver Members and up get access to an Extended Cut of this video. 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. MEMBERS VIDEO: youtu.be/n3OrDCTdMdY BECOME A MEMBER: YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join or My Site: 599cd.com/THMember LEARN MORE: 599cd.com/ValidateEmail SUGGESTED COURSE: Access Beginner 3: 599cd.com/ACB3 LINKS: Input Masks: 599cd.com/InputMask Validation Rules: 599cd.com/ValidationRule Microsoft's Validation Rule: 599cd.com/MSEMVALRUL Wildcards & Like: 599cd.com/Like Input Masks of Varying Length: 599cd.com/InputMaskVariable Table Level Validation: 599cd.com/TLValidation Email Validity Rules: tinyurl.com/y97v8nbl Email Validity Rules: en.wikipedia.org/wiki/Email_address OTHER COURSES: FREE Access Beginner Level 1: 599cd.com/Free1 $1 Access Level 2: 599cd.com/1Dollar FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: 599cd.com/THFree Blank Template: 599cd.com/Blank Contact Management: 599cd.com/Contacts Order Entry & Invoicing: 599cd.com/Invoicing More Access Templates: 599cd.com/AccessTemplates ADDITIONAL RESOURCES: Donate to my Tip Jar: 599cd.com/TipJar Get on my Mailing List: 599cd.com/YTML Contact Me: 599cd.com/Contact TechHelp: 599cd.com/TechHelp Consulting Help: 599cd.com/DevNet Twitter: twitter.com/LearningAccess en.wikipedia.org/wiki/Microsoft_Access products.office.com/en-us/access microsoft.com/en-us/microsoft-365/blog/access 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 QUESTIONS: Please feel free to post your questions or comments below. Thanks.