Recent content by kris2011

Cheers Pat but no use either. Works fine but I need a customised error message (without resorting to VB, my students brains will explode)

Thanks David but tried that and it doesn't work Tried this too which also doesn't work: (Is Not Null And Like "*@*.co.uk") Or (Is Not Null And Like "*@*.com")...

I want to allow (without the spaces obviously): bob@ hotmail.com bobby@ hotmail.co.uk sid@ hogan.net But there MUST be an email address entered so cannot leave blank Basically I want this to work: Is not null AND Like "*@*.co.uk" Or Like "*@*.com" Or Like "*@*.net" but the logic is wrong...

Hi, I have this validation rule: Like "*@*.co.uk" Or Like "*@*.com" Or Like "*@*.net" How do I stop it from allowing null values within the rule..... (?) IS Not Null and Like "*@*.co.uk" Or Like "*@*.com" Or Like "*@*.net" doesn't work. With thanks I don't want to write any code or use...

Cheers Missinglinq

Does anyone know why this doesn't work for me at form level in Access 2010? Between DateAdd("yyyy",-65,Date()) And DateAdd("yyyy",-10,Date()) I can enter 28/06/1946 But 01/01/1970 and 01/01/1930 both fail the rule??? 01/01/1970 should be OK as it is between the parameters.