I am having difficulty with a combobox, It is reading data from a list of dates, but when an item is selected it displays in the text format. (01/12/2003 -> 37956). How do I stop this from happening?

many thanks

Martin

Hi

Have you tried adding a ' infront of the dates. e.g '01/12/2003

Let me know if this does not solve your problem.

Regards
Marnus

Thanks,

This does work, but I wish to use these combobox dates to filter a report which contains date formats, converting the combobox to text would require converting the report dates to text aswell.

Martin

Use the CDate() function

Darrell L. Embrey

Many thanks