How to Add Field Validation Message MS Access

Quick summary

Adding a field validation message in MS Access lets you define a validation rule and display a custom error message whenever a user enters data that violates that rule. This keeps your database data clean and guides users toward correct input without manual intervention.

Steps

1. Right-click the table in the navigation pane and select Design View.
2. Click on the field where you want to add a validation message.
3. In the Field Properties pane, locate the Validation Rule property.
4. Enter a validation rule and click OK.
5. In the Validation Text property, type a message to display when the rule is violated.
6. Save the changes by clicking the save icon.