enter month, day, auto-fill current year, how??

T

tlyczko

I have co-workers who would like to only enter the month and day and
not have to type in the year, as the current InputMask requires.

Can this be done?? I searched this group but only found posts about
incrementing.

The field has to be editable after it is completed, in case one date is
say during December 2005 and the next is in January 2006, which is two
separate years.

I was thinking something like 99/99/ + Year(Now()), but I know that's
not quite it, or that something in the AfterUpdate function should do
this, but I am not quite certain how to make it more or less
transparent to the user or apparent that the year is being correctly
filled in for them.

Thank you,
Tom
 
M

Mark

If you don't use an input mask, the user can enter the month and day, and
Access will assume it's the current year. If you enter 3/21 or 03/21 or
3-21, Access will store and display the date as 3/21/2005.
 
T

tlyczko

After some more searching, I discovered that removing the input mask
does what I want. I just have to caution users to always type the
slashes.

Meanwhile, thank you to everyone who read this message.

:) tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top