How to Validate Email Format MS Access

Quick summary

This tutorial shows how to validate email format in Microsoft Access using the built-in Validation Rule property in Design View. Setting a validation rule on an email field prevents incorrectly formatted entries from being saved to your database.

Steps

1. Right-click the table and select Design View to open the table structure editor.
2. Click on the email field where email addresses will be entered.
3. In the Field Properties pane, locate the Validation Rule property and click the ellipsis icon to open the expression builder.
4. Enter the validation rule expression and click OK to confirm.
5. In the Validation Text property, enter a user-friendly error message to display when invalid input is detected.
6. Click the save icon to save the changes and apply the validation rule to the field.