input mask for email addresses

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Forms Programming / December 2005

input mask for email addresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BRC - 31 Dec 2005 01:28 GMT

Has anyone seen a good input mask for email address that will catch input
errors like "," instead of "." etc?
Thanks BRC

Reply to this Message

Allen Browne - 31 Dec 2005 03:18 GMT

Try something like this in the Validation Rule of the field in the table:
Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Has anyone seen a good input mask for email address that will catch input
> errors like "," instead of "." etc?
> Thanks BRC

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.