storing date as entered on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two text boxes in a form 3
Hello happy new year to all, Text box input for year of purchase 0
Entering Dates 2
Forcing a date entry format of dd/mm/yyyy 1
Allowing only one record to be checked in subform. 1
Excel Vba to change displayed year automatically. 14
Date Conversion Solar date to Gregorian 2
Entering dates into cells as mm/yy or yy 4

Back
Top