Expanding rows

[TonC]

:bug: Hello,
In my DB, I have a few tables with a lot of information. I created some forms to work with this information. You can set some characteristics, like the number of rows you like to show in a combobox.
But now my question,
suppose you've got more than 200 records to show in a combobox when you search for relevant information, is there a way to show this information in more than one row?
Can I get more rows to the right of the existing row? Remember there is only one piece of information in the record I need.

Can you give me some information about this topic. I've searched the internet about this subject, but it seems I cannot find it. (see my smiley at the beginning of this thread.)

Thanks for your help.
TonC

[SamT]

Maybe.

Get the 200(?) rows from that DB field into an array. Assign sections of that array into "Columns" of a 2D array and set the List to the 2d array.

[TonC]

Okay, okay, but how to do so ? I admit, I do not have the knowledge of VBA to make such array. Is there any example DB.

[SamT]

Check this site. He is a Compatriot of yours. I think.

snb's VBA for smarties Contents (http://www.snb-vba.eu/inhoud_en.html)

BTW, That is a neat idea, splitting a long list into several ListBox Columns. Please share that code with us when you are finished. Thank you.