Today, I opened my database and discovered that all dates are 02/05/2/01
which should be 02/05/01. I checked the date format without any errors.
Umm: I still don't know whether you mean May or February (or January?)!
What date format are you using exactly? What would you like?
Remember that _Access_ converts text to dates using Regional settings
formats first (and then goes on to try to coerce any old stuff using any
old combination of months, days, and years).
On the other hand, _Jet_ is very specific about the formats it uses.
Finally, _Access_ will convert the date back into text using (1) textbox
Format property, or (2) field Format property, or (3) Regional Settings.
You need to be clear what you actually have stored in your table (try a
query like
SELECT Day(MyDate), Month(MyDate), Year(MyDate) FROM MyTable
to be absolutely clear where the error is happening. Then you need either
an update query to change the existing wrong ones, or to check out your
forms or reports.
Hope that helps
Tim F
