# How to Validate Numeric Ranges MS Access

> To validate numeric ranges in MS Access, open the table in Design View, select the target field, and enter a rule in the Validation Rule property. Next, input an error message in the Validation Text property and click the save icon to apply your changes.

Canonical: https://livedemo.ai/tutorials/how-to-validate-numeric-ranges-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a5296ab56e05a00fffd14/preview?step=1

## Steps

1. Right-click on the table and select 'Design View'.
2. Click on the field where you want to validate numeric values.
3. In the 'Field Properties' pane, locate the 'Validation Rule' property.
4. Enter a validation rule and click 'OK'.
5. In the 'Validation Text' property, enter an error message.
6. Save the changes to apply the validation rule by clicking the save icon.