When your field should contain only one from a very short, specific list of values, validation rules may be your answer. Laurie Ulrich explains how input masks work and how to implement them in your database.
- [Instructor] When it's important…that your database users restrict their entries…to a particular series of acceptable values,…a validation rule can be the simplest way…to enforce that restriction.…To impose a validation rule,…open your table in Design view…and click on the field that needs the rule.…Click the Validation Rule row and type the list of values.…No matter how many you have,…just type them all out,…each separated by the word or.…Last, type the validation text in the next row down…in Field Properties to concisely explain the rule.…
This is the text that will appear…if somebody types a value that isn't in the list.…That's all there is to it.…To test it, just open your table in Datasheet view…and attempt an entry not in the list in the validation rule.…
Author
Laurie Ann Ulrich
Released
2/27/2019- Planning your database
- Building tables
- Setting field properties
- Creating relationships
- Creating forms for data entry
- Finding data with queries
- Updating records with queries
- Building better reports
Skill Level Intermediate
Duration
Views
-
Introduction
-
1. Planning
-
Storyboarding1m 6s
-
-
2. Building a Table
-
3. Field Properties
-
Using input masks1m 19s
-
-
4. Relationships
-
Editing relationships1m 4s
-
5. Data Entry
-
Fast forms with subforms1m 12s
-
Create combo and list boxes1m 27s
-
Adjusting tab order in forms1m 15s
-
-
6. Queries
-
Finding missing data1m 7s
-
7. Reports
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Making validation rules