for an activeX combobox, the value and text properties are identical. they
should always produce the same output.

--
Regards,
Tom Ogilvy

"augustus" wrote in message
...
Hi,

I got a spreadsheet with comboboxs connected to a database. Each combobox
basically load two columns of data: One for displying to user, another to
be
store in database. However, everytime I save the spreadsheet, and load it
up
again (when I can't finish the work), the Text property get changed to the
value in Value Property. WHY? Is there way to prevent this?
Running Win2000 & Office2003.

Thanks