Click here to Skip to main content
14,737,155 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi everyone,

I am coding an application using access db. In my application I am having an email field which is saved in access db. So for this what will be the datatype for this field?
Any input mask or validation rule?? And how to do this??

Any help is kindly appreciated.
Posted

There is no specific datatype for email, so your only options are to either create a validation rule for the field that checks your entry is correct, or, the best way to do it would be to validate your email in the user interface itself. That way you can let the user know there is a problem before submitting to the database.

Hope this helps
   
Comments
Saumyavemula 1-Jun-11 7:59am
   
Can you help me how to do because i am new to access db.
Wayne Gaylard 1-Jun-11 8:30am
   
Google is your friend.
You can declare Text as DataType for Email
and to validate it that the text entered is
Valid Email Id I suggest you to
Follow this Link [^]
May this Can Solve Your Problem.
And to Learn More About Access db and Forms
please visit this Link [^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900