2-Dim array as list to a ListBox

[Joakim N]

Hi,



I have an Unbound ListBox (named lstMyList) in a Form. I want to add a 2-Dim array (named avMyLIst) as list to the listbox. In Excel I use:

Me.lstMyList.List = avMyLIst()

However, I noticed that the property .List doesn't exist in Access. How can I assign a 2-Dim array as a list to an Unbound ListBox in Access? Is it possible?

[CJ_London]

you need to set the rowsource type to value list then you will need some code to parse through your array to create a semi colon separated string which will look something like

1;option1;2;option2;3.......

[Joakim N]

Doesn't I need different signs (Semi colon and something else) to separate new row & columns? If I use only semi colon, it seems that eveything will be placed in column 1. I want to have column 2, 3, ... .

[Joakim N]

Got it!

with Me.lstStaffAssignedToJob
    .AddItem "1;2;3"
    .AddItem "4;5;6"
end with

That created 3 columns and 2 rows. Now I know how to proceed.

Thanks!

I appreciate your help.

[CJ_London]

it seems that eveything will be placed in column 1. I want to have column 2, 3, ... .

it looks like you have a solution, but normally you would set the column count to the required number of columns.

Whilst we're at it:

use the column widths property to hide or size columns as required - if you just want to hide the first column all you need to enter is 0

the bound column is the value that will be returned when the user selects an item