Automatically finnishing the date in a form

[Guest]

Is it possible to have the year completed automatically in a form, so that
you can just select "6" and the date is entered as "2006"?

Thanks so much for your help

 

[John Vinson]

Is it possible to have the year completed automatically in a form, so that
you can just select "6" and the date is entered as "2006"?

Thanks so much for your help

Access defaults to the current year. Just don't put any input mask on
the date field textbox at all; if you type 8/25 it will fill in
08/25/2006 automatically.

If you're using a Date/Time field to store ONLY a year... don't. A
date/time field stores a precise moment of time, not a whole year. You
could use an Integer number field with a default value property of
Year(Date()) to automatically fill in the current year.

John W. Vinson[MVP]