G
Guest
We are in the UK therefore we express dates like this: 19/10/2007.
In my tables and forms I have not set any date format for the various date
fields and controls, but I have an input mask like this: 00/00/0000;0;_
Everything works OK except that (understandably) we are forced to enter the
year in full.
We would like to be able to enter just 19/10/07 and then upon leaving the
field (control) Access would then convert this and display and store it in
full, as 19/10/2007. (We definitely need it in full otherwise I would simply
knock a couple of zeroes out of the mask).
Sorry if we appear to be Lazy Brits but those extra two characters do make
quite a difference if you're inputting dates all day, every day!
Any way that we can do this??
Many thanks
In my tables and forms I have not set any date format for the various date
fields and controls, but I have an input mask like this: 00/00/0000;0;_
Everything works OK except that (understandably) we are forced to enter the
year in full.
We would like to be able to enter just 19/10/07 and then upon leaving the
field (control) Access would then convert this and display and store it in
full, as 19/10/2007. (We definitely need it in full otherwise I would simply
knock a couple of zeroes out of the mask).
Sorry if we appear to be Lazy Brits but those extra two characters do make
quite a difference if you're inputting dates all day, every day!
Any way that we can do this??
Many thanks