input masks

[SDSL95]

I am working with a database that allows me to put in the month and day
(Mar-03)
every time the program addes this year to it (03-Mar-09) how do I go about
changing this to ready (03-Mar-10)

 

[Steve Schapel]

SDSL95,

When entering a date, if you don't specifically enter the year, Access
assumes the current year.

Most experienced database designers have learned that it is best to avoid
the use of Input Masks for dates.

It would be possible to use code or macro to add a year to the date after it
is added. But this is a bit complicated. What happens once we reach
January, in which cae the default year used will be 2010... do you want the
data entry to then automatically change to 2011? And if you use the After
Update event of the control (which would probably be the most appropriate),
you will also have to allow for multiple edits of the date, in which case
you only want the year added once. Etc.

So my advice really is to abandon the Input Mask, and enter the date fully,
including year, or use a calendar to enter, or some other method.

 

[SDSL95]

thanks

SDSL95,

When entering a date, if you don't specifically enter the year, Access
assumes the current year.

Most experienced database designers have learned that it is best to avoid
the use of Input Masks for dates.

It would be possible to use code or macro to add a year to the date after it
is added. But this is a bit complicated. What happens once we reach
January, in which cae the default year used will be 2010... do you want the
data entry to then automatically change to 2011? And if you use the After
Update event of the control (which would probably be the most appropriate),
you will also have to allow for multiple edits of the date, in which case
you only want the year added once. Etc.

So my advice really is to abandon the Input Mask, and enter the date fully,
including year, or use a calendar to enter, or some other method.

--
Steve Schapel, Microsoft Access MVP




.