Illegal Date

[orna]

If you enter an illegal date in a form (like: 29/02/06)
Access turn it to what looks reasonable to him. (06/02/29)

The date format is "dd/mm/yy"
Where (Event) can i catch and check the date.

TIA

 

[PHV]

My suggestions:
Field level validation in the BeforeUpdate event procedure of the relevant control.
Record level validation in the BeforeUpdate event procedure of the form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[orna]

Thanks!!!!!!!!!