input masks for email addresses

  • Thread starter Thread starter dave.degroot
  • Start date Start date
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
 
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?
 
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 (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]
 
Back
Top