X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Multi-dimensional Array To Multicolumn Listbox, Access 2003    
post Nov 25 2017, 03:17 AM

Posts: 1
Joined: 22-May 17

Hello, I've been following this forum for a while and learning from it, today I need help to do the following:

I have a multidimensional array and I want to pass it to a multicolumn listbox in a pop-up formulary so that you can click on it to choose a value from it, and I do not know how to do it.

The case is that the array I have it full (5x4), I have created a form only with a listbox of 5 columns, but I do not load the data of the array in the listbox when the pop-up form is opened.

If someone can help me, I would be very grateful.

A greeting.

Sorry for my English (translated with the google translator)
Go to the top of the page
post Nov 25 2017, 11:00 AM

Access Wiki and Forums Moderator
Posts: 71,595
Joined: 19-June 07
From: SunnySandyEggo

Hi abadmi,

Welcome to UtterAccess!

I am guessing Colin meant to say to use Join rather than Split. Make sure your Listbox Row Source Type is set to Value List and then apply your Regional separator for a Listbox Row Source. For example, in the U.S., we use a semicolon, so I might use something like the following code:

Me.Listbox.RowSource = Join(ArrayName, ";")

Hope it helps...

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
post Dec 10 2017, 02:51 AM

Posts: 7
Joined: 2-December 17

Be careful doing that. Value lists have a limited amount of characters you can use. That confused the [censored] out of me because I'm new to access and had a growing list of usernames (+ info) that one day went past that limit (which i didn't know existed, my bad).
I only use value lists with non-growing lists that I know are within limit (obviously). Otherwise, i just import the data into a temp table and use that as the listbox source.
This post has been edited by slacka: Dec 10 2017, 02:54 AM
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    23rd February 2018 - 05:39 AM