Email Input Mask for Access
Does anyone know how to format an input mask for an email field in access?
Thanks!
Web Development
Does anyone know how to format an input mask for an email field in access?
Thanks!
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
blnReallookingEmail=
instr(strEmailAddress,"@") and
instr(right(strEmailAddress,4),".")
'this assumes that there are no more than three characters after the last dot.
by manda
by manda
This discussion is closed to new replies.
Sort by Trending