Listbox capacity - 65535

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
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.
 
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!
 
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
 
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.
 
Back
Top