Validation rule for email address

[dragct]

Good Morning!

I am trying to put a validation rule into my table for an email address, to dictate that the last part of the email MUST be @my.lonestar.edu

I have reviewed this forum, as well as others and have tried various ways.

Is null or (Like "*?@my.lonestar.edu*")
Is null or ((Like "*?@my.lonestar.edu*") And (Not Like "*[ ,;]*"))
Is Null OR ((Like "*?@?*.?*.?*") AND (Not Like "*[ ,;]*"))

The problem is that when I either try to test the rule on exisiting data or import new data, I receive an error that my data does not match the rule. I have verified that my email addresses are all @my.lonestar.edu

Any advice or input would be appreciated.

Kim

 

[jDa]

Try it without the ?

No: Is null or (Like "*?@my.lonestar.edu*")
Yes: Is null or (Like "*@my.lonestar.edu*")

 

[dragct]

Still ended up with an error "Existing data violates the new setting for the "Validation Rule" property for the field, but if I say accept anyways, it posts the majority of the records...still working on it.

Any other ideas?

 

[Kiwiman]

Howzit

I tried

Is Null Or Like "*@my.lonestar.edu"

as the validation rule against a table, and saved the table with existing data - that did not meet this criteria. I received a similar message as you got as it asks you to validate the existing data first.

Are you sure your exisitng data is either Null (note not an empty string) or ends in @my.lonestar.edu ?

 

[MSAccessRookie]

Try it without the ?

No: Is null or (Like "*?@my.lonestar.edu*")
Yes: Is null or (Like "*@my.lonestar.edu*")

I have an observation that I believe needs to be made, even though it may not be related to your problem.

I am not sure what the trailing "*" in your string is there for, since you said "the last part of the email MUST be @my.lonestar.edu". Adding the trailing "*" would also allow addresses that included "@my.lonestar.eduxxx" or @my.lonestar.educator", and I do not think that is what you meant.

 

[dragct]

Thanks everyone! Got it working. I appreciate the help.

 

[MSAccessRookie]

Thanks everyone! Got it working. I appreciate the help.

Glad to be of help (if I was). Perhaps you can tell us what the resolution was?