Validating a text field
Where you go from there depends on which condition you used.
When you validate text data to check if it contains a certain value, there are two additional steps to take after selecting the condition: condition is used for entering regular expressions to create custom validation criteria.
There are three types of validation rules in Access: 1.
Field Validation Rule You can use a field validation rule to specify a criterion that all valid field values must meet.
The hint is displayed in the input field before the user enters a value.
If the condition isn’t met, an error message is displayed to the user.
You can vet or validate data in Access desktop databases as you enter it by using validation rules.
You can define validation rules for table fields and for controls on forms.
When you define rules for tables, those rules apply when you import data.
Tip: Learn more about regular expressions in our Java Script tutorial.
attribute specifies a hint that describes the expected value of an input field (a sample value or a short description of the format).
When data is entered, Access checks to see whether the input breaks a validation rule – if so, the input is not accepted, and Access displays a message.