email input mask

[deirdre]

in access i am trying to make a input mask for email address does anyone have
one?

 

[Biometric45]

I am also trying to figure out how to set up to dbl-click
on an email address entered into a table or form so that
it opens an Outlook email page for the addressee. Is
there a feature in Access2003 or is a macro needed? If so
does anyone have a macro to get that action to work?
Thanks

 

[Poseidon]

An input mask is okay for fixed-length strings, but an email address is never
a fixed length. You may want to try using VBA to check for an '@' symbol and
a '.' after the @ symbol to make sure that it is formatted properly.

 

[John Vinson]

in access i am trying to make a input mask for email address does anyone have
one?

You can't. An input mask is a VERY limited tool; it is simply not
sophisticated enough to validate an email address. To do so you'll need to
write some VBA code for use in the BeforeUpdate event of a textbox, to check
that the string contains an @ sign, at least one period after the @, and no
illegal characters such as blanks (although in some systems an address such
as

"John Hancock"@continental_congress.org

would in fact be legal.

It's not a trivial task!

John W. Vinson/MVP