Thread: Disable auto default to current year

Hope somebody can help.
I have produced an Access database for work which happens to have a number of date & time fields. The problem I have is that whilst the automatic default to current year when inputting dd/mm is perfectly ok for most of the fields it is important that one of the date fields does not default in this way as it is a "expiry date" which I want to ensure the operator has entered the full date manually. The expiry date in most instances is 12+ months ahead of the current so as you can see the current year is not acceptable.

Many thanks for taking a look.

Araujo

Not sure if you can avoid a default current date autofill for partial dates, but it is possible to set the table field default value to next year with something like this:

=DateSerial(Year(Now())+1,Month(Now()),Day(Now()))

Cheers,

hi,

Where are the dates being entered?
Is it in fields on a Userform, straight into a table or...?

Rob