Share via

Validation Rule for Access Email Field

Anonymous
2017-09-22T21:27:31+00:00

In the "Validation Rule" of the Field Properties for the EmailAddress of the Access tblStudent this rule: <Is Null OR ((Like "?@?.?") AND (Not Like "[ ,;]*"))> produces the following error: Syntax Error, Missing Operator

How to correct it.

Thank you

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Duane Hookom 26,820 Reputation points Volunteer Moderator
    2017-09-22T21:54:37+00:00

    You seem to be missing some "*". Try this from Allen Browne's site Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2017-09-23T12:53:38+00:00

    Did you enter this into the Validation Rule for the field? By "it did not work" I would expect a little more clarification like "it allowed me to enter..." or "an error message ...".

    Thank you again.

    Yes I entered the text of the rule for the field "Email".

    The error message was in French: 

    "Erreur de syntaxe (opérateur absent) dans l'expression de validation au niveau de la table"

    Google translation:

    "Syntax error (absent operator) in the validation expression at table"

    I must add that the Email Address field <Email> has over a 1000 records. Some of them are <mailto:>, others are <http://>. I want these last ones be <mailto:> also. Because when a secretary wants to send a message to one of the students, it will will be easier if all entries are <mailto:>

    Hope it helps.

    Thanx

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2017-09-23T01:34:16+00:00

    You seem to be missing some "*". Try this from Allen Browne's site Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

    Thank you, but it did not work.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Duane Hookom 26,820 Reputation points Volunteer Moderator
    2017-09-23T02:34:20+00:00

    Did you enter this into the Validation Rule for the field? By "it did not work" I would expect a little more clarification like "it allowed me to enter..." or "an error message ...".

    Was this answer helpful?

    0 comments