input mask with prefilled date information

[Guest]

I want to use an input mask that has prefilled date information in it. The
user is going to be entering lots of dates and they are all for the same
year. How can I make the input mask pop up as _ _ / _ _ /2007 (the 2007
already filled in). I can get it to appear this way but when I try to enter
information it gives me an error message. My current input mask reads:
99/99/"2007";;_ and is not working.

 

[Joan Wild]

I always find that input masks just get in the way, particularly when it comes to dates.

Consider training your users. The can just enter the month and day and Access will assume the current year.

It does depend on the Regional Settings in Control Panel on their computer, though.

If the short date format is set to mm/dd/yyyy, then they need to enter
8/12 for yesterday.

If the format is set to dd/mm/yyyy and they enter that, Access will assume Dec 8 and not August 12.

In either case though, they don't need to enter the year. It's a good idea to give the control an unambiguous format that will show the user how their entry was interpreted. I suggest
mmm/dd/yyyy or dd/mmm/yyyy or yyyy/mmm/dd or???

Just use mmm for the month, and things will be clearer to the user.