form validation

[kris2011]

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.

 

[missinglinq]

Your code works fine for me, so my guess would be because you appear to be from one of those places that use the British date format, and MS Access is very US-oriented in these matters!

Allen Browne, himself an Aussie and one of the premier authorities on MS Access, has an excellent paper on the subject including, I believe, some workarounds:

http://allenbrowne.com/ser-36.html

Linq ;0)>

 

[kris2011]

Cheers Missinglinq