Check date validity

[klasse]

Hi,

I have a form where users enter a date that later will be use for other stuff. I am looking for some lines of code or a function to put on the After Update event in order to check the validity of such date.

Thanks,

Klasse

 

[nickjar2]

Hi Klasse,

Could you give a little more detail please?

Nick

 

[THoey]

If you define the field as a date, not text, Access will validate it for you. Terry M. Hoey

 

[klasse]

Hi,

I have a textbox, where I use a mask for short date.
Input mask is 00/99/00;0;_
dd/mm/yy

But if I enter 32/10/05 where 32 is day, 10 is month and 05 is year, this is not a valid date !
Therefore it will take it as the 05th of the month 10, of year 1932

I would like it to display a message advising that it is not a valid date (because of the day 32)

Thanks!


Klasse