Search results
-
K
is not null with like
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... -
K
form validation
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.