Link to home
Start Free TrialLog in
Avatar of msanzenb
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?
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

I thought combo boxes in VB were all one-column, unlike the Access combo boxes that were multi-column, but still store one value.
Avatar of msanzenb
msanzenb

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.
I've checked all of those and all were ok...any other suggestions?
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks

Pete