I'm having a weird problem with date fields in Access 2007.
When the format is not explicitly set, it defaults to General Date.
This built in format is displaying dates incorrectly.
For example, 04 Nov 2010 01:26:54 PM displays as 04 Nov 10308 01:26:54 PM
and 15 Nov 2010 02:33:54 PM displays as 15 Nov 10319 02:33:54 PM
This happens in datasheet view & form controls.
If I explicitly format any date fields or controls using dd a format like mmm yyyy hh:nn ampm it displays correctly.
BUT if you edit the field by clicking in it or pressing F2, you have to edit the date in the incorrect format.
When you leave the control it is displayed correctly again.
Looking at the difference in these numbers it seems like Access is mixing up dates with days.
I've looked in the Windows Control Panel & my Regional Settings are fine - the rest of my system is displaying dates correctly.