Quick summary
Cross-field validation in MS Access lets you enforce data integrity by writing expressions that compare multiple fields within a table. By setting a Validation Rule and custom Validation Text in Design View, you ensure invalid data is caught before it's saved.
Steps
- Right-click the table in the Navigation Pane and select Design View.
- Click the ellipsis icon in the table properties to open the validation rule builder.
- Enter an expression that references multiple fields to define your cross-field rule.
- Type a meaningful message in the Validation Text property to display when the rule is violated.
- Click the save icon to save all changes to the table.
