# How to Validate Email Format MS Access

> To validate email format MS Access, open the table in Design View, select the email field, and open the Validation Rule property. Enter the rule, add a user-friendly error message in the Validation Text property, and save the changes to apply the rule.

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

## Steps

1. Right-click the table and select 'Design View'.
2. Click on the field where emails will be entered.
3. In the 'Field Properties' pane, locate the 'Validation Rule' property and click on the ellipsis icon.
4. Enter the rule and click 'OK'.
5. In the 'Validation Text' property, enter a user-friendly error message.
6. Save the changes to apply the rule by clicking the save icon.