How to Create Custom Validation Rules MS Access

Quick summary

This demo walks you through how to create custom validation rules in Microsoft Access using the Field Properties pane in Design View. You'll learn how to write a validation expression, set a user-facing error message, and save the rule to enforce data integrity in your Access table.

Steps

1. Right-click the table in the Navigation Pane and choose Design View.
2. Click the field you want to validate.
3. In the Field Properties pane, locate the Validation Rule property and click the ellipsis icon.
4. Enter your custom validation rule as an expression, then click OK.
5. Enter a message in the Validation Text property to display when the rule is violated.
6. Click Save to save your changes and test the rule.