•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 397,810 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,517 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 7310 | Replies: 4
 |
•
•
Join Date: Jul 2005
Location: South East Asia , Singapore
Posts: 52
Reputation: 
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
Email Validation Rule with MS ACCESS Hi,
I am using MS ACCESS. I want to validate a particular field.
To check whether if its a valid email address with a @
So anyone have tutorials or website to reccomend or even reply off hand with the expression to check for @ in a string?
Thanks alot.
I am using MS ACCESS. I want to validate a particular field.
To check whether if its a valid email address with a @
So anyone have tutorials or website to reccomend or even reply off hand with the expression to check for @ in a string?
Thanks alot.
•
•
Join Date: Jan 2007
Location: India
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by LiBOC 
Hi,
I am using MS ACCESS. I want to validate a particular field.
To check whether if its a valid email address with a @
So anyone have tutorials or website to reccomend or even reply off hand with the expression to check for @ in a string?
Thanks alot.
You Can Validate A Field Which Must Contain "@"
for That Open Table In Design View & in General Tab Go To "Validation Rule" & Edit Function with <A href="mailto:"InStr(1,[email],"@")>=1">"InStr(1,[email],"@")>=1"
& Creat A error Msg If u Want Please Note That In Above Syntex Second String "[email]" is Name Of Field For Which You want To Add Validation
[IMG]http://www.daniweb.com/techtalkforums/C:\Documents and Settings\v-shalar\Desktop\access.bmp[/IMG]
Prakash Srivastava
India
India
•
•
Join Date: Mar 2007
Location: Manchester, UK
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: Email Validation Rule with MS ACCESS •
•
•
•
Originally Posted by PCsrivastava
Yes
You Can Validate A Field Which Must Contain "@"
for That Open Table In Design View & in General Tab Go To "Validation Rule" & Edit Function with <A href="mailto:"InStr(1,[email],"@")>=1">"InStr(1,[email],"@")>=1"
& Creat A error Msg If u Want Please Note That In Above Syntex Second String "[email]" is Name Of Field For Which You want To Add Validation
http://www.daniweb.com/techtalkforum...top\access.bmp
Hi Prakash
Thanks for the message posted but I am havng troule to understand the logic you have shown in the code.
I have also tried this code in MS Access but it is not working. if you could then can you please send me the proper solutionI mean the code which works in your MS Access version which I can copy and paste and understand it.
This is not my assignment so don't think anything in that perspactive. I am doing advance stuff than this. So please do reply me either here or at my mail id which is : ankit_upadhyay2020@yahoo.com
Cheers.
•
•
Join Date: Mar 2005
Posts: 65
Reputation:
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
Try looking at the InStr function examples on this page:
http://office.microsoft.com/en-us/ac...547271033.aspx
Chester
http://office.microsoft.com/en-us/ac...547271033.aspx
Chester
•
•
Join Date: Jun 2008
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hey i am did this validation rule for a project i did 3 months ago, i readead your thread and found the way i did it. just place this text in to your validation rule field and it works a dream:
((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))
it works perfectly and the company i just built a database for have no issues with it, it can even tell if someone enters " accedentally due to them not configuring their language settings properly. I hope all you guys out there find this useful.
cheers Remi
((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))
it works perfectly and the company i just built a database for have no issues with it, it can even tell if someone enters " accedentally due to them not configuring their language settings properly. I hope all you guys out there find this useful.
cheers Remi
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
•
•
•
•
access advertisment apple browser cell code combo computing core data dropdownlist email encryption eu eudora firefox gmail google imap ip mac microshaft microsoft mobile module mozilla ms net news onecare open source opinion penelope phishing phones pro processor professional reuse scam security spam spammers spamming stocks technology thunderbird virus web webmail
- Microsoft Access 2003 Validation Rule (MS Access and FileMaker Pro)
- Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS** (MS Access and FileMaker Pro)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Increment ID
- Next Thread: Auto fill Reports into a form in Access 07
