Hey all, I'm an Access beginner. I met with a problem and can't solve it.
Currently, I have a field in the table stored Date/Time data. In table's design view, I set the Format as dd/mm/yy and set the Input Mask as 99/99/00. To match the table, I set up a textbox in the form, and set the textbox format to dd/mm/yy and the Input Mask as 99/99/00. Now something weird happens: After I enter the date as 30/08/04 (which is Aug. 30th/2004) and move on to the next object, the data changes automatically to 04/08/30! I don't know why that happens and how to prevent the MS Access from changing the data automatically. Could anyone give me some tips or suggestions?
And "Welcome to the Forum"
What country are you in? It seems there is something with your systems Regional Settings which is what Access is using. Go to ControlPanel and then RegionalSettings and see how your system is set up.