I have a short date field on a table. If an invalid date is entered eg 29/02/05 Access changes it to 05/02/29 without any explanation. my region settings are Australia with my date format of dd/mm/yy. I don't want to make the user go through selecting a date from a calendar because it takes too long. Is there an easy way to stop Access changing the date as entered?