# How to Create Cross-Field Validation MS Access

> To create cross-field validation in Microsoft Access, right-click the table in the Navigation Pane and select Design View. Click the ellipsis icon to set a validation rule, enter an expression involving multiple fields, add a meaningful message in the Validation Text property, and click the save icon.

Canonical: https://livedemo.ai/tutorials/how-to-create-cross-field-validation-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3959ab56e05a00fdfab7/preview?step=1

## Steps

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.