Validation rule for email

[something]

Hiya,

I having trouble to write a validation rule so that it check at the end of the email address it has .com or .co.uk or .org.

I tried this [CODE]Like “[A-Z]* @[A-Z].com” OR “[A-Z]* @[A-Z].co.uk” OR “[A-Z]* @[A-Z].net” OR “[A-Z]* @[A-Z].org”[/CODE]

And this

((Like "*?.com?*") Or ((Like "*?co.uk?*") Or ((Like "*?.org?*"))))

And error message appeared



I have no idea what to do

Thanks

[aytee111]

You can't use Like in VBA, only in queries.

If Right(fieldname,4)=".com" OR Right(fieldname,6)=".co.uk" OR ........

[orange]

You can't use Like in VBA, only in queries.

Do you have a reference for this??

I use it in vba quite often.

If Left(Me.txtSearchValue, 1) Like "[0-9]" Then
       'searching for number

Do Until .EOF
70       .FindFirst "Log like '*Nix *'"

60     If qdf.SQL Like "*Conca*" Then
70     Debug.Print i & " ***" & qdf.name & "***" & vbCrLf & qdf.SQL

[aytee111]

OK, I must be mistaken! Not sure why it has never worked for me. Nice to know.

[Micron]

First, when you declare an error message occurred, provide the error number and most, if not all, of the error message.
Using two wildcard characters with Like just looks wrong - Like "*?.com?*" - Moreso LIKE "*.com" or LIKE "*.com*"

If you're writing code, you could also use multiple instances of the InStr function. Assuming you are checking against a form field on the active form:

If Instr([Me].[txtEmail],".com") Then
Instr function details here
https://www.techonthenet.com/access/...ring/instr.php