Combo Boxes and Dates

  • Thread starter Thread starter codytheretriever
  • Start date Start date
C

codytheretriever

Have a form with a combo box whose source is a worksheet
column of specific dates which are in the format 11/05/03.

When you click on the combo box on the form you see a
listing of the dates and they are shown in the format
11/05/03.

When you select the date you want the value that then
shows as the selected date is in decimal format, 37930.

Have the same problem with another combo box that is used
to select time values.

What do I need to do to get the selected value in the
combo boxes to retain the format they started with?

Any help greatly appreciated!
 
It might help to see what your code looks like, but you
can try adding:

Format(CODE_THAT_GETS_THE_COMBOBOX_VALUE, "mm/dd/yy")

Hope that helps.

Regards,
James S
 
Back
Top