P
Paul
Hi Y'all,
I have a table field which I've formatted to MM/YY. On a form the
input box for that field is formatted the same. However if I enter a
date such as 03/08 (March 2008) it becomes 08/07. Access sees 03/08 as
3rd August and adds the current year. The data stored is 03/08/07.
How can I stop this happening? I assume I can just use a formatted
number field but surely there's a way to keep the date format?
Thanks in advance!
Paul
I have a table field which I've formatted to MM/YY. On a form the
input box for that field is formatted the same. However if I enter a
date such as 03/08 (March 2008) it becomes 08/07. Access sees 03/08 as
3rd August and adds the current year. The data stored is 03/08/07.
How can I stop this happening? I assume I can just use a formatted
number field but surely there's a way to keep the date format?
Thanks in advance!
Paul