The best way to handle dates is to have users enter full dates meaning a month,
day, and a four digit year.   You can explicitly set formatting options to
*display* dates in a way that ignores regional settings, but I don't know of a
way to manipulate the assumptions Access will make when only a partial date is
entered.

You could use an unbound control for data entry and use AfterUpdate code to take
that entry and produce a date value for insertion into the table and then have
complete control over how that conversion is done.

In my experience, it enters the current year (by the system clock) if
you just type days and months. Do you mean that if you type

04/05

into a textbox bound to a Date/Time field it stores April 5, 2029? I'd
expect it to store April 5, 2005.

Enter dates unambiguously, e.g. type in

05-Apr-2005

                 John W. Vinson[MVP]