input masks for email addresses

D

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
 
D

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
Click to expand...

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?
 
J

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
Click to expand...

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 [email protected] 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]
 
Top