storing date as entered on form

A

aft3rgl0w

hey all, some help with this would be much appreciated!
i have a textbox on a form, in which i enter the date a cd was released.
the format is mmm-yy. what i want, is to be able to type in "may-06" and
have the date stored as 01-May-06. when i type this in presently, it saves
the date as 06-may-07 (current year). to get it to store properly i have to
type out the year in full. i want to just be able to enter a 2 digit year
and have it save as such. thanx!
 
K

KARL DEWEY

Haven't you heard everyone went to 4-digit year for the new century. I do
not know how your form is laid out but it seems like your best bet is to use
an unbound text box with an After Update event or macro call to set the value
to your field. Let it parse May-06 to 1 May 2006.
 
Top