Input Mask for email Address

[Gina]

Can some kind person help me with this?

I need an input mask for email addresses so that the username can be
random length alphanumeric characters before the @ symbol and random
length alphanumeric domain names with a mandatory period in the domain
name.

The mask should allow correct email formats to be entered into the
table but reject others.

e.g the following would be accepted:

(e-mail address removed)
(e-mail address removed)

incorrect formats rejected such as:

mary.hotmail.com
sam67@hotmail
@worldmail.net

I have read up the help files in access and searched the net for the
format for this but can not find anything permitting random length
characters.

This came about because my database at work has many incorrect entries
for email addresses.

With thanks
Gina

 

[Guest]

Hi Gina

I would not use an input mask - try validating the field in the table before
update,

Have a loom at Allen Browns site for details

http://allenbrowne.com/ValidationRule.html

Good luck