COLUMN COUNT PROBLEM

[Guest]

Hi-
I have a list box which contains a list of fields(LIST59). You pick a field
and then go to the combo box(Combo61) and a set of values will appear in the
box based on which field u selected. My problem is that I have fields which
are yes/no based and others that are just text. When I select a field with
one column it shows the values, then I can click on a yes/no fiels and it
shows yes/no, but if i try to go back to a field with one column it comes up
blank..Here is my code is ther anything wrong..

Dim strRow as String
Select Case Me.List59
Case Is ="Voltage"
StrRow =" ....."
Me.Combo61.ColumnCount =1
Case Is = "Changed"
strRow = "..."
Me.Combo61.ColumnCount = 2
Me.Combo61.ColumnWidths = "0,1440"
End Select
Me.Combo61.RowSource = strRow

 

[Jeff L]

It's because when you are changing back to 1 column your column width
setting is still 0, 1440. The column width for the one column is 0, so
it appears to be blank. You need to change that setting when you
change back to one column.

Just a suggestion: You might find it more useful to name your controls
with more descriptive names. It will aid you in the long run,
especially if you need to debug something and you have a lot of
controls you are dealing with.

Hope that helps!