Exceeding the 65536 Items in a ComboBox Limit

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

Guest

I need to exceed the 65536 items limit for a combobox in Access 2003. Adding
a filter for the combobox to reduce the number of items won't work for my
application. I saw the "Forms 2.0 Combobox" in the list of ActiveX controls.
Will this exceed the limit, and if so, what is the limit and how do I use
this control? I also discovered the "eXComboBox" and read that its limit is
150000. Has anyone ever used this control? Could anyone recommend a way to
surpass the 65536 limit without adding a filter for the combobox?
 
You're really doing your users a disservice: even 600 records in a combobox
is far too many to have to scroll through.
 
As few others have said, a combo box is good for maybe 600 items, and after
that you need to change your approach.

such a large number of entries is not workable at all, not to mention the
torture you will put users though.

It is not clear how, or in what context you are using this combo box, but if
you are searching for something, then consider building a form (or form +
sub-form) to do this type of search for you. Here is blurb on what I mean:

http://www.members.shaw.ca/AlbertKallal/Search/index.html
 
Back
Top