Get all the videos in this Access VBA collection 100% FREE by signing up at https://vbahowto.com/ms-access-tutorial
In this video I talk about:
ms access text validation
validation rule access
input mask in access
an input mask
validation in access
microsoft access table
Here is the video:
Data validation is a useful method to guide users on what type of data to enter into program.
There are 3 levels of data validation:
a. table level – validation at the table level and available to all forms based _
on the table.
b. form level – validation for only items on the form
c. code level – when there is no suitable form validation
Use this handy table as reference for input mask building
| Character | Description | ||
|---|---|---|---|
| 0 | Digit (0 though 9, entry required; plus [+] and minus [-] signs not allowed) | ||
| 9 | Digit or space (entry not required; plus and minus signs not allowed) | ||
| # | Digit or space (entry not required; blank positions converted to spaces, plus and minus signs allowed) | ||
| L | Letter (A through Z, entry required) | ||
| ? | Letter (A through Z, entry optional) | ||
| A | Letter (entry required) | ||
| a | Letter (entry optional) | ||
| & | Any character of a space (entry required) | ||
| C | Any character of a space (entry optional) | ||
| .,:-/ | Decimal placeholder and thosands, date, and time separators. (The actual character used depends on thre regional settings that are specified by the options in the Regional Settings Properties dialog box. | ||
| < | Causes all following characters to be converted to lowercase. | ||
| > | Causes all following characters to be converted to uppercase. | ||
| ! | Causes the input mask to display from right to left, rather than from left to right. Characters typed into the mask always fill in from left to right. You can include the exclamation point anywhere in the input mask. | ||
| \ | Causes the character that follows to be displayed as a literal character. Used to display any of the characters listed in the table as literal characters (for example, \A is displayed as A) | ||
| Password | Setting the Input Mask property to the word Password creates a password entry text box. Any character typed in the text box is stored as the character, but is displayed as an asterisk (*). | ||
| Please remember that by default your input mask character is not stored in the database. For example, if your input mask is “LL\-009999”, and you later want to search for the “-” character by using the Instr function, it won’t be there. Modify your input mask to “LL\-009999;0”, this will store the “-” character and your Instr searches will find the “-” character. | |||
<< MS ACCESS FORM OBJECTS – PT3 | MS Access Validation – PT2 >>
Learn Access VBA: Understand Tables, Queries, Forms, and Reports
Learn Access VBA: From Zero to Database Hero If you’ve ever opened Microsoft Access and wondered how all the pieces fit together — tables, queries, forms, and reports — this tutorial is made for you. In just a few minutes, you’ll understand how Access works behind the scenes and see how VBA (Visual Basic for […]
How To Make An Access Form Time Picker
Here is a relatively easy way to select times for your time entry text boxes. It’s a reusable form that allows you to pick a time from an Access form. There are probably different ways to do this but here is the way I would do it. On the form that has the time fields, […]
How To Parse A Flat File In Excel VBA
In another post I demonstrated how to access a file on your computer using the MS Office Library. Here it is if you don’t know what I’m talking about. In this post, I am going to show you how to access the file and load it into your spreadsheet. I will do the same thing […]
How to pick a file to load In VBA
How to Pick a File in VBA: FileDialog & GetOpenFilename Explained When building Excel VBA applications, you’ll often need to let users pick a file to load in VBA. Instead of hard-coding file paths, you can use built-in dialogs that make file selection easy and user-friendly. VBA offers two main approaches: FileDialog object (flexible, customizable) […]
Support these sponsors: