How to Create Cross-Field Validation MS Access

Guide

1. Right-click the table in the Navigation Pane and select 'Design View'.

2. Click the ellipsis icon to set a validation rule.

3. Enter an expression that involves multiple fields.

4. Enter a meaningful message in the 'Validation Text' property to display if the rule is violated.

5. Click the save icon to save the changes.