input masks for email addresses

[dave.degroot]

Can anyone advise me on a way to force the user to enter, on an
Access
95/97 form, a correct email address, as:-

sometextinlowercasewithdotordotshyphensunderlines@moreofthesame


I would appreciate any help.

Thanks,

David

 

[dave.degroot]

Can anyone advise me on a way to force the user to enter, on an
Access
95/97 form, a correct email address, as:-

sometextinlowercasewithdotordotshyphensunderlines@moreofthesame

I would appreciate any help.

Thanks,

David

Maybe I should have asked, is it better to use input masks in the
table design or in the form design and stipulate the input mask?

 

[John W. Vinson]

Can anyone advise me on a way to force the user to enter, on an
Access
95/97 form, a correct email address, as:-

sometextinlowercasewithdotordotshyphensunderlines@moreofthesame


I would appreciate any help.

Thanks,

David

An input mask simply doesn't have enough power to do this. It's a very limited
tool - useful within its range, but not beyond!

Note that (e-mail address removed) is a perfectly valid email address too,
and that most (but maybe not all!) domains are not case sensitive.

You may need to have some VBA code to check for valid structure of the
address, rather than a mask; and the only way to see if it's a correct address
is to send it and see if it gets received!

John W. Vinson [MVP]

 

[Tim Ferguson]

Note that (e-mail address removed) is a perfectly valid email address
too, and that most (but maybe not all!) domains are not case
sensitive.

So is [email protected]

Legal forms are defined in RCF 2822 see http://tools.ietf.org/html/rfc2822

There are loads of helpful regular expressions at, for example,

http://www.regular-expressions.info/email.html


Hope that helps


Tim F

 

[dave.degroot]

So is [email protected]

Legal forms are defined in RCF 2822 seehttp://tools.ietf.org/html/rfc2822

There are loads of helpful regular expressions at, for example,

http://www.regular-expressions.info/email.html

Hope that helps

Tim F

Thanks guys. I'll check out those links as well.

Cheers,
David