Rules of validating email addresses
You should not have to specify the current field as a part of the rule unless you are using the field in a function.
Restrictions on types of characters to be entered in a field may be easier to do with an Input Mask.
A validation rule is one way to restrict input in a table field or a control (such as a text box) on a form.
Validation text lets you provide a message to help users who input data that is not valid.
First, I would read this article I Knew How To Validate An Email Address Until I Read The RFC.For example, a date field might have a validation rule that disallows values in the past. Record Validation Rule You can use a record validation rule to specify a condition that all valid records must satisfy.You can compare values across different fields using a record validation rule.There are three types of validation rules in Access: 1.Field Validation Rule You can use a field validation rule to specify a criterion that all valid field values must meet.Back in the days of yore, you could just connect to the user's mail server and use the VRFY command and verify that an email address was valid, but spammers abused that privilege and we all lost out.You can vet or validate data in Access desktop databases as you enter it by using validation rules.Expressions can also perform mathematical operations. For example, the expression You can add a field validation rule and/or a record validation rule.A field validation rule checks input to a field, and is applied when the focus leaves the field.To add validation rules to a table, you open the table and use commands on the Fields tab of the ribbon.To add validation rules to a form, you open the form in Layout view and add rules to the properties of individual controls.