Validation rule for email field

[Rocio_LB]

I want to have a validation rule that enforces the use of "@" for the "email"
field of a table.
How is the validaton rule created? I am not very proficient in code, and
relativelly new to Access, but I have checked the Expression Builder and I
could not find an expression that will allow typing and undefinite amount of
caracters before and after the '@" symbol.
I will appreciate if someone could give me an indication of how this is
written.

Thank you for your help!
Rocio

ps. the same question has been posted in the 'programming' and 'design'
sections.

 

[Wolfgang Kais]

Hello "Rocio_LB".

I want to have a validation rule that enforces the use of "@" for the
"email" field of a table.
How is the validaton rule created? I am not very proficient in code,
and relativelly new to Access, but I have checked the Expression Builder
and I could not find an expression that will allow typing and undefinite
amount of caracters before and after the '@" symbol.

How about this:
Like "?*@?*.?*"

 

[Rocio_LB]

Wolfgang,
Thanks very much for taking the time to respond to my question. I haven't
yet tested the code... but it looks very much like what I am looking for. Tks
again!