Listbox capacity - 65535

D

David Mueller

I searched around but I don't see any workarounds for getting more rows into
a listbox. Is there a newer listbox control that can hold more?

Thanks
 
D

Duncan Bachen

David said:
I searched around but I don't see any workarounds for getting more rows into
a listbox. Is there a newer listbox control that can hold more?

Thanks
Click to expand...

What does the textbox contain that has so many values? Maybe there is a
way to filter it down a little bit.
 
D

David Mueller

It is a listbox, and it contains the population of a pension plan. Some
plans have over 65535 participants. I think I just have to let it go. Users
can sort the listbox by the columns, so they eventually find their way to the
balance of the population; however, there are several plans with more than
130 participants. For those cases, I will likely need to filter by
alphabetical ranges.

Thanks.
 
D

Douglas J Steele

That's a hard-and-fast limit in Access.

As Duncan points out, though, it's hard to imagine a requirement for that
many rows in a listbox. Surely you don't expect your users to scroll through
that much data!

Take a look at what Allen Browne has at
http://www.allenbrowne.com/ser-32.html for an alternative idea for handling
hundreds of rows of data.
 
D

David Mueller

That is a good point. I thought about that... after it contains so many rows
there isn't much they can do with it anyway.

The real value of the listbox is to give users a glance at a subset of the
population that contains data inconsistencies and/or errors. With that in
mind, 65535 really isn't so bad!
 
T

Tom Lake

David Mueller said:
It is a listbox, and it contains the population of a pension plan. Some
plans have over 65535 participants. I think I just have to let it go. Users
can sort the listbox by the columns, so they eventually find their way to the
balance of the population; however, there are several plans with more than
130 participants. For those cases, I will likely need to filter by
alphabetical ranges.
Click to expand...

I'd create a subform to display the data and use code to select the record the user
clicks on or sort by that column.

Tom Lake
 
K

Ken Snell \(MVP\)

You cannot put more than 65535 records into a list box.

You'll need to use an intermediary filtering method to restrict the number
of records that are displayed.

I have a sample database that shows how to do this for a combobox in
combination with a textbox; you could use a listbox in place of the combo
box:
http://www.cadellsoftware.org/SampleDBs.htm#CombinedTextComboBoxes

There are many examples of filtering methods on web... for example, see
http://www.datastrat.com/Download2.html and see the ExpandingSearch features
there. And see http://www.allenbrowne.com/ser-32.html for another example.
 
Top