Discussion Locked

Email Input Mask for Access

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone know how to format an input mask for an email field in access?

Thanks!

5 replies

by seagull data services

Unfortunately not.
Input masks are intended to force input into a structured field, e.g. dates, phone numbers, etc.
Internet E-mail addresses are generally not structured data, i.e. the parts of the email address are not of fixed length.
The format username@company.com could be anything from me@home.com to Christopher.Shuttleworth.White.Davis@TheAssociationOfPeopleWithLongAndHypenatedNames.info
Even the top level domains are not of fixed length!

by manda

Right but is there anyway to make sure that it is in the format of whoever@whoever.domain. I want to insure that there is a @ and a .xxx after the email so people don't enter something like anywho@anywhere when it should be anywho@anywhere.com

by seagull data services

blnReallookingEmail=
instr(strEmailAddress,"@") and
instr(right(strEmailAddress,4),".")
'this assumes that there are no more than three characters after the last dot.

This discussion is closed to new replies.