Listbox with 2 Column

[WaZda]

hi every body,
can someone help me populate on a listbox, 2 columns of 2 differents fields of a table? I hope the question is clear enough. I want to have 2 column on my listbox. And the first column will have informations of field_1 of the table, and the second column will have informations of field_2 of the table.
Someone pls help.

 

[Andrzejek]

Unlike VBA, VB 6 does not have 'out of the box' listbox with columns. Sorry.

What you can do is:

For i = 1 To Rec.RecordCount
    ListBox.AddItem rec!field_1 & " - " & Rec.field_2
    rec.MoveNext
Next i

Have fun.

---- Andy

 

[HughLerwill]

>What you can do

in a fixed spaced font

 

[HughLerwill]

or checkout the ListView Control

 

[strongm]

> " - "

You may be better off replacing that with vbTab (and then messing about with the LB_SETTABSTOPS message if necessary)

 

[WaZda]

thanks a lot everybody for your various tips.

 Andrzejek (Programmer)  	

Unlike VBA, VB 6 does not have 'out of the box' listbox with columns.  Sorry.

I think this answers my question.
I understand it's simply no possible. Ok got it.

 

[Error7]

or checkout the ListView Control as HughLerwill said.
The ListView will do exactly what you want.

[gray]Experience is something you don't get until just after you need it.[/gray]

 

[tedsmith]

There is a brilliant list box free from Doug Anderson.
It has multiple columns and lines of any color and font, graphics etc and very easy to use

http://www.thai-software.com/OpenSource/default.htm

and select the Smart List Box

 

[vbSun]

Found these

http://vbnet.mvps.org/index.html?code/listapi/cooltabs.htm

and the code for using LB_SETTABSTOPS as strongm had already pointed out.

http://vbnet.mvps.org/index.html?code/listapi/cooltabs.htm