checking for correct date

[Angie]

Is there a function which checks to make sure that the
date entered is correct. ie not 30 days in february

 

[Douglas J. Steele]

Try IsDate. Note, however, that it's not 100% accurate, as Access will bend
over backwards trying to accept your input. For instance, it will accept
14/12/2003 even if your Short Date format has been set to mm/dd/yyyy (Access
just assumes that you meant dd/mm/yyyy). For total days in a month, though,
you won't have any problems.

 

[angie]

Thanks, I will have to write something then lol

-----Original Message-----
Try IsDate. Note, however, that it's not 100% accurate, as Access will bend
over backwards trying to accept your input. For instance, it will accept
14/12/2003 even if your Short Date format has been set to mm/dd/yyyy (Access
just assumes that you meant dd/mm/yyyy). For total days in a month, though,
you won't have any problems.

--
Doug Steele, Microsoft Access MVP






.