Max entries in a combo box

  • Thread starter Thread starter Jerry Evans via AccessMonster.com
  • Start date Start date
J

Jerry Evans via AccessMonster.com

I am trying to increase the max entries of a combo box. I have over 100k
rows in my table. Is there a way to do this? If not, are there any
alternatives?
 
If it's bound, there shouldn't be a limit, right?

Is a combo box the best control for 100K+ items anyhow? Personally I would
use either a listbox or a subdatasheet instead.
 
Just agreeing with Mr Steele... there is no way in the world that a list of
100k plus entries is going to be in any way user friendly. You need to
allow users to filter it in some way... exactly how is down to how users
want to do it. Ask them.
 
Hi Steve,

it seems, that the listbox i use is limited to 65.536 items, though it's
bound to a query (with 80.000 items).
System: Win2k
MS Access 2000 (9.0.3821 SR-1)

Please help.

Regards
Norbert
 
That's a hard-and-fast limit on listboxes (in both Access and VB). However,
in my opinion even 65K records is far too many to expect a user to scroll
through in a control.

You might be able to adapt what Allen Browne has at
http://www.allenbrowne.com/ser-32.html to work with listboxes, rather than
comboboxes.
 
Thank you for your quick reply.
Indeed, to scroll through the whole data would be a pain. But the user gets
the possibility to find a certain item.
Then (after founde one) he/she will be in the area where they can easily
scroll through and thats the really advantage of a listbox
- clearly arranged facts with sourounding facts of other items!
So, I hope I'm able to use the hints from Allen Browne.

But it's definitly?
max. Items are 64k

Regards and Thanks
Norbert
 
BTW:
Just visited your home page.
I live in bavaria (better, in frankonia - called fraenkische schweiz), the
area with the highest concentration of private beer-breweries per population.
Have a amused look at www.saddelfest.de.
It's in german only, but get in contact with Manfred (his home page), he has
an excellent english knowledge.
We have a (push-)bike tour twice a year, visting all the breweries on the
way. That's really fun!
 
Yes, it's definite. I believe it has to do with the fact that internally,
the listbox uses an unsigned Integer field as an index.
 
Back
Top