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.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline