Might be stupid Access Question

[Jose Esteves]

okay I just need to know how I can make a email input
mask. I wanna be able to only accept the input in an email
format ie (e-mail address removed) any help would be gladly
appreciated

 

[RobFMS]

It may be suggestable to create text boxes for each of the parts, such that:

<textbox> @ <textbox> . <textbox>

HTH

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[John Vinson]

okay I just need to know how I can make a email input
mask. I wanna be able to only accept the input in an email
format ie (e-mail address removed) any help would be gladly
appreciated

It's surprisingly difficult, given the wide variety of valid EMail
address formats. (e-mail address removed), (e-mail address removed),
etc. - counting periods will not work. With some fairly elaborate code
you can check for the presence of an @ and the absence of blanks or
special characters, but it's perhaps more work than it's worth (since
a valid *format* does not guarantee a valid *address* anyway!)