date validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top