I am using Access from Office 365 to administer a Defensive Driving Database. We enter personal info from the student, DL, DOB, address, etc. We enter DOB by typing the month, date, and last two digits of the year so 6/21/1946 would be entered 6/21/46. For some unexplained reason when I am entering DOB's for people born in the 1920's, 1930's, and 1940's the year birthdate is shown as 20xx. For example, if I type DOB as 6/21/46 and hit Enter the DOB is shown as 6/21/2046. 6/26/22 becomes 6/26/2022, and 6/26/32 becomes 6/26/2032. For people born in the 50's, 60's, 70's, etc this problem doesn't occur. 6/26/46 becomes 6/26/1946. I have tried repairing Access, uninstalling and reinstalling Access with no success. My son living in another household has the database as well but has no problems as I have described above. Any ideas of what's going on? Recommendations or suggestions to fix? Oh yes, when I using Access 2003 and Access2010 the same problem occurred.
Frank
El Paso, Texas