input mask for email addresses

B

BRC

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

Allen Browne

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
input mask issue 0
How prevent input mask appearing in locked date field? 2
Input Mask - IP Address 3
input mask 4
Text box input??? 1
changing the Phone Number Input Mask to all for extensions 2
Changing login email address for office 365 admin (O365 Busines) 0

Top