Date conversion upon input

[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

 

[Guest]

A mask is just a bunch of slots to control how you must put the data into the
record. If your field is a datetime datatype then it is always stored the
same no matter how it is put in. You use formatting to control the display.

So take out the two extra zeros, try it Mikey, you'll like it.