Date Problem (1 Viewer)

[mr_fish]

hi all,

I've got a form with a text box you can enter a date in mmm yy format, it works o.k if you enter any 06 date (e.g jun 06) but when you enter any other year 07 08 etc. it defaults back to 06 everytime. Not sure why this is happening. The underlying table has mmm yy as format type as well if this makes any difference.

Thanks in advance for any advice that can be given on this problem.

jon

 

[mr_fish]

Looks like another access quirk, if the month/year the user enters is in the same year as the system time the user can enter the date in MMM YY format and it works, otherwise the user has to enter MMM YYYY format for other years.