If you want to store your data in a date field, Access has to be able to
resolve
At least the month, day and year. If you don't want to type in "01-02-05"
and only
want to type in "02-05" then you need to write a sub procedure that takes
your "02-05"
and adds an "01" to the front of that data, creating what Access needs
"01-02-05".
I would suggest that you use an unbound text control to enter the "02-05".
Have your Date field on the form but not visible.
The subprocedure would be attached to the afterupdate event of the unbound
control.
The procedure would take the "02-05" entered in the unbound control,
add the required "01" to the front and
Assign the resulting "01-02-05" to the datefield control.
Certainly the typing of the "01" seems easier and less fault prone but.....
Kevin C
"luanhoxung" <lu********@yahoo.comwrote in message
news:68******************************@localhost.ta lkaboutdatabases.com...
hi !
i have 1 field in format date/time, in format tab i set mmm-yy.
my goal is when i type 02-05, the record will be FEB-05.
But it records May-06(current year){i think 02-May-06).
any help with appreciated.
thanks alot.
luan from Vietnam.
