In this video, I will teach you how to use an Input Mask in your Microsoft Access tables and forms. We will create input masks for telephone numbers, ZIP codes, dates, and more.

Mckenzie from Chandler, Arizona (A Gold Member) asks: The phone number field in my database is a mess. Some people are typing in dashes, others parentheses, others with nothing at all. I've got 239-555-1212, (239)555-1212, and 2395551212. I recently wanted to make a report showing customers by area code, and I couldn't do it because my data isn't uniform. How can I force my users to use ONE format for entering phone numbers?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to dynamically change the input mask based on another field. For example, for US & Mexico, use "00000" for the ZIP code. For Canada use "L0L 0L0" for the Postal Code. Same field, different input masks. We'll use a little VBA to swap them on the fly.

MEMBERS VIDEO:
   • Microsoft Access Input Mask MEMBERS O...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/InputMask

LINKS:
Replace Function: https://599cd.com/Replace
Variable Length Input Masks: https://599cd.com/InputMaskVariable
Input Masks: https://599cd.com/ACB3
Input Masks: https://599cd.com/ACB6
Input Masks: https://599cd.com/ACX4
Format Property: https://599cd.com/Format

COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, input mask, Control data entry formats with input masks, Create an Input Mask, setting input masks, Create Input Masks in Access, What is the Input Mask Wizard, Defining Input Masks, How To Create An Input Mask In Access, How to Set an Input Mask, input mask access example, input mask access phone number, input mask codes, input mask characters, input mask zip code

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.