populating a list box

[Guest]

Is there a way to populate a multiselect list box in this way. With the data
coming from one column.

Alabama Alaska Arizona Arizona
California Colorado Connecticut Delaware

 

[Douglas J. Steele]

It's possible, but not really that easy.

You either need to write a failry wonky query that would return the data
that way, or create a recordset on the table and use the AddItem method to
add four at a time, or write one of the special functions outlilned in
http://msdn2.microsoft.com/en-us/library/aa831449(office.10).aspx.

What do you need the data arranged that way? You can only select a row from
a listbox, not an individual cell.

 

[Guest]

I don't need the info in that format. I would like to have a dropdown list
box or a multiselect combo box. Since I can't have either, I wanted to show
all of the info horizontally in a multi select listbox. In conclusion, I
just need a way to be able to select multiple states without creating a large
form to display them all.

Thanks

 

[Douglas J. Steele]

Afraid Access doesn't have anything like that.

As I indicated, while you can certainly get a list box (or combo box, for
that matter) to display the data that way, there's no way to have Access
know that you're trying to select Alaska, and not Alabama ,Arizona or
Arkansas.

There may well be 3rd party controls that give you that capability, but I'm
not aware of any that work with Access (I tend not to use 3rd party controls
due to the problems they can cause with the References collection, so I
really don't pay that much attention to them)

 

[Guest]

Ok, I guess this my last question. I have a list box that is populated with
the states. It shows the first 6 and a scroll bar, but the scroll bar
doesn't work. the only way I can access the info not shown is by hitting the
arrow keys on the keyboard or dragging cursor down on the info. How can I
make the scroll arrow work?

Thanks again.

 

[Douglas J. Steele]

Can't say I've ever heard of this problem before.

You haven't fiddled with the form's AllowUpdate (or the other Allow
properties), or with the control's Locked property, have you?