Date Validation

[orna]

I'm sure its a problem for a many of us, but couldnt find an answer.
Try to prevent from the user to enter a wrong date like "29/02/07"
and since Access knows better what it means it turns it to "07/02/29".
this expression: IsDate(format("29/02/07","dd/mm/yy")) gives true.
Now to the question:
Where and how can i check the date validity befor Access change it??

TIA

 

[Rich]

Why are there quotes surrounding your dates?

 

[orna]

Just for display, usually its a date control

 

[orna]

Anybody?????????????

 

[Bat17]

only thing I can think of is standard validation rules to prevent dates too far from 'now' to be entered

Peter