All, using Access 2016..i have a text box on a form that needs to record as email..how can I force my users to enter an email address?
All, using Access 2016..i have a text box on a form that needs to record as email..how can I force my users to enter an email address?
I would use a function of some sort (RegEx, etc) to validate the text as an email address. You could use the before update event of the textbox or the form. I've got an older one around here somewhere if you can't find one.
Here's a tutorial:
http://www.geeksengine.com/article/v...email-vba.html
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Got it solved..thanks
Glad you got it working.