Value Property vs Text property

[Guest]

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

 

[Tom Ogilvy]

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

 

[Guest]

Tom,
But why is it that we can specify them with different value initially?
Example,

Sheet1.cbxStructType.Clear
Sheet1.cbxStructType.BoundColumn = 1
Sheet1.cbxStructType.ColumnCount = 2
Sheet1.cbxStructType.ColumnWidths = "0;30"
Sheet1.cbxStructType.TextColumn = 2

Do While Not RS.EOF
Sheet1.cbxStructType.AddItem RS.Fields("StructID").Value
Sheet1.cbxStructType.List(Sheet1.cbxStructType.ListCount - 1, 1) =
RS.Fields("StructDescrip").Value
RS.MoveNext

Say Row 1, Column 1 = Me, and Column 2 = You
This will give me Value=Me, and Text=You

Even after I save the file, this will remain the same (I checked under
Design mode). However, the moment I close and reopen this book again, the
Text will change to Value.

Regards
Augustus

 

[Tom Ogilvy]

You are correct (and I misspoke with reference to this specific situation).
the boundcolumn corresponds to the value property and the textcolumn
corresponds to the text property. However, if you are setting the
boundcolumn and textcolumn in code, then these settings are non-persistent.
Set them in design mode using the properties window and they should remain.

 

[Guest]

Sorry Tom, didn't mean to mislead you, I actually have setted them in design
mode, and not in code (the code was used initailly, 'cause I got few
comboboxes doing the same thing, but different database, they were then
changed to comment).

Regards
Augustus