Problem With Input Mask On Form

[crhodus]

I've got an imput mask on one of my forms that is having problems. Since the first of 2002, one of my fields will not record the year 2001 correctly.

This field on the form (named STDate) has 99/00;;_ for the imput mask. Also, the table that houses this data has an imput maks of 99/00;;_

This field is set up so that only the month and year are displayed. The user only has to enter in 11/01 for the month and date November 2001. After the user types in the date, 11/2001 is displayed in the field.

The problem that is happening now is that when the user enters in 11/01, Access is changing the year to 2002, so that 11/2002 is displayed.

Can anyone help me?

Thanks!


[This message has been edited by crhodus (edited 01-02-2002).]

 

[David R]

Can you post the code that allows you to only enter the month and year? Whenever I enter xx/xx, it defaults to the current year, and I'd be curious to see how you got around that (it's probably possible, I've just never put the brainpower into it).

You might be able to make a workaround that checks if the date entered is later than today, and takes a year off of the data with DateAdd().

HTH,
David R