MM/DD date format no year

[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,

 

[S.Clark]

By default, if you enter a date without the year, it will use the current year.

 

[Arvin Meyer [MVP]]

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.

 

[Phil]

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,

 

[KARL DEWEY]

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.

 

[Ronald Verner]

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,