input mask for mail address

[Guest]

Can anyone tell me what the input mask (or format statement) for a valid
email address should be, so that it holds at least a @ and a dot(.)
so CCCCCCCC\@CCCCCCC\.CCCC
or something like that...but this is not correct
?

 

[Allen Browne]

Try setting the Validation Rule of the field in your table to something like
this:
Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

 

[Guest]

Thanks Allen,
but i would like to do this in the validation rule property of the form
field (i dont want to change the back end tables) to filter out wrong input.
So i pasted your solution in the validation rule of the form field, but it
is not working...
what did i wrong? Can you explain the meaning of the ? in the like part?

Try setting the Validation Rule of the field in your table to something like
this:
Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Can anyone tell me what the input mask (or format statement) for a valid
email address should be, so that it holds at least a @ and a dot(.)
so CCCCCCCC\@CCCCCCC\.CCCC
or something like that...but this is not correct
?

 

[Allen Browne]

The ? insists that there is at least one character.

So a valid email address must consist of at least one character before the
@, at least one more character before the dot, and at least one more after
that.

Further, you specify the characters that must not appear anywhere in the
email address, such as a space, comma, or semi-colon.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen,
but i would like to do this in the validation rule property of the form
field (i dont want to change the back end tables) to filter out wrong
input.
So i pasted your solution in the validation rule of the form field, but it
is not working...
what did i wrong? Can you explain the meaning of the ? in the like part?

Try setting the Validation Rule of the field in your table to something
like
this:
Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

Can anyone tell me what the input mask (or format statement) for a
valid
email address should be, so that it holds at least a @ and a dot(.)
so CCCCCCCC\@CCCCCCC\.CCCC
or something like that...but this is not correct
?