validating e-mail in access 2000

  Tree3 10:11 23 Oct 03
Locked

how do i validate an e-mail in access 200 with an input mask or validation rule?

  Tree3 20:48 23 Oct 03

please help i need to know if you can make sure it has "@" in it

  Taran 21:14 23 Oct 03

IS the field to be completed from an online form are are you using an Access form for a dekstop type database application ?

The principles are the same, but there are certain consideration to be taken into account for an online form.

T

  Taran 21:33 23 Oct 03

I'll assume that you're using a standard Access form.

You can get up and running (sort of) programmatically by using something along the lines of:

If Not Me![TextX] Like "*@*" Or Not Me![TextX] Like "*.*" Then

MsgBox ("Invalid e-mail address")


End If


Change the two [TextX] entries in the above code to the name of your text field. This validates the @ sign and makes certain you have a . in the address.

Note that there are potentially other issues involved, depending very much on how you want your forms to run and if there are other fields you want to automatically leap to after this one has been filled.

It's a starting point though.

T

  Tree3 11:39 24 Oct 03

the form is for a personal database not for online use

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…