The user will not be able to enter an invalid date if the text box is bound
to a Date/Time field in the table.
If the text box is unbound, set its Format property to Short Date, and
Access will not accept a bad date.
If the date makes no sense to Access, it is likely to spin the date around
and try other combinations. Therefore the example you gave might be
interpreted as 5 June 2031 instead of being rejected as a bad date. You
can't stop it doing that, but you can limit that if you display the year as
4 digits. To do that, open the Windows Control Panel, and choose Regional
Settings. Set your Short Date to:
dd/mm/yyyy
Since you seem to live in a d/m/y country, you might get some help from this
article:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
