msanzenb
asked on
Combobox showing only first column
I have a multicolumn combobox but when i select the item i want. only the first column appears. I want to see all columns when a value is clicked. How do I do this?
I thought combo boxes in VB were all one-column, unlike the Access combo boxes that were multi-column, but still store one value.
ASKER
It is an Access database. Sorry for any confusion
Couple of possibilities...
(0) Your .RowSource property only has one column.
(1) Your .ColumnCount property is only 1.
(2) Your .ColumnWidths property has a bunch of zeroes in it, and only one non-zero (like 0;1.5;0;0;0)
(3) You are using a Value List that does not jive with the .ColumnCount property, as in 2 columns, 5 values
(4) The .ListWidth property needs to be increased to cover the width of all columns.
(0) Your .RowSource property only has one column.
(1) Your .ColumnCount property is only 1.
(2) Your .ColumnWidths property has a bunch of zeroes in it, and only one non-zero (like 0;1.5;0;0;0)
(3) You are using a Value List that does not jive with the .ColumnCount property, as in 2 columns, 5 values
(4) The .ListWidth property needs to be increased to cover the width of all columns.
ASKER
I've checked all of those and all were ok...any other suggestions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks
Pete
Pete