validate email before update on form

  • Thread starter Thread starter Song Su
  • Start date Start date
S

Song Su

I searched validate email and come up with this:

Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

I don't want to put in table validate because my daily macro to import from
text file may fail (it may contain single period as email). I want to put
before update event of my form

How to put If statement to validate? My field is called email
 
For most e mails you will use @ as the validator ut if you say that some e
mails will not contain @ then you need to add in something else to show it is
an e mail.

Can you give an example of an e mail that "does not" contain @
or you could work it our ourself by just playing around with it
Say your internal mails always contain # or ^ then you would need to add
these
like this
Is Null Or ((Like "*?@?*.?*")OR ((Like "*?#?*.?*")OR ((Like "*?^?*.?*")

As you can see validating e mails is a pain as the spamer will try and get
round whatever you do

Oh yes - I would not automate this in an update query (someone will just
have to sit and look at them) as even spam mail addresses will contain @
 
Back
Top