Hi,
I have a combo box that will shows month and year, i.e. January 2002. The source data is formatted in date data type (with mmmm yyyy so it can shows month year).
However, in the combo box I could not managed to keep the format (mmmm yyyy). Well actualy it lets me keep the format right after I edit it. But after you close the form, and reopen it it will shows 1/1/2002 instead of January 2002 after you enter the combo box, even if the selection in the combo box shows January 2002.
Can someone help me.
thanks
I have a combo box that will shows month and year, i.e. January 2002. The source data is formatted in date data type (with mmmm yyyy so it can shows month year).
However, in the combo box I could not managed to keep the format (mmmm yyyy). Well actualy it lets me keep the format right after I edit it. But after you close the form, and reopen it it will shows 1/1/2002 instead of January 2002 after you enter the combo box, even if the selection in the combo box shows January 2002.
Can someone help me.
thanks