How to Validate Date Ranges MS Access

Quick summary

This tutorial shows how to validate date ranges in Microsoft Access by setting a Validation Rule and Validation Text on a date field in Design View. Follow these steps to prevent invalid date entries and enforce data integrity directly at the table level.

Steps

1. Right-click the table and choose 'Design View' to open the table structure editor.
2. Click on the date field where date entries will be entered to select it.
3. In the 'Field Properties' pane, navigate to the 'Validation Rule' property.
4. Enter your validation rule expression and click 'OK' to confirm.
5. Set the 'Validation Text' property to provide a custom error message shown when the rule is violated.
6. Click the save icon to save changes and apply the validation rule to the table.