MM/DD date format no year

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi,
Is there a way to format the input for a date field using only the month and
day. I have a program where I input data for a given year and don't want to
enter the year with every date input.
Thanks,
 
It isn't a date without a year. If you don't want to bother entering a year,
Access will do it for you. Just enter:

12/29

and Access will add the rest. It must be in that form though, or you will
wind up with an error.
 
Hi,
Thanks for your reply. That did help, but is there a way to have the year
default to a given year? For example, I'm doing input for the year 2009 and
it is 2010.
Thanks,
 
On your data entry form you could have two unbound text boxes, one to enter
the year you are enter data for and other to enter month/ day (12/29).
A macro action SetValue of bound text box with
CVDate([Forms]![DataEntry]![MyMonthDay] & "/"
&[Forms]![DataEntry]![MyYear]) using AfterUpdate event.
 
Phil said:
Hi,
Is there a way to format the input for a date field using only the month
and
day. I have a program where I input data for a given year and don't want
to
enter the year with every date input.
Thanks,
Click to expand...
 
Back
Top