Populating Multi-Column Combo Box

[EddyLLC]

Can anybody help me populate a combo box in VB6 with data from an Access database. The issue I'm struggling with is the combo box must have multiple columns. Each record in the database has two fields and both fields must appear when the combo box pull down is activated.

Thanks

 

[TLowder]

Does it truly need to have multiple columns or would a comma or whatever between the strings work? I don't think the standard combo box has multiple columns, but I bet you can find a control that does. A google search for "multiple column combo box vb" turned up

http://www.codeproject.com/KB/cpp/multicolumncombo.aspx,

and many others that look promising.

Tom

 

[tedsmith]

Be careful about one called Smartlistbox
It can crash your program by conflicting with other things

 

[Andrzejek]

One way to 'fake' a multi columns in a regular combo box is to use a fixed length font, like a [tt]Courier New[/tt] with the Tab between columns
[tt]
Smith Joe Accounting
Clinton Bill President
Bunny Bugs Comedian[/tt]


Have fun.

---- Andy

 

[strongm]

Or it might be possible to modify the query to combine the two fields into one