Exceeding the 65536 Items in a ComboBox Limit

[Declan]

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?

 

[Douglas J. Steele]

You're really doing your users a disservice: even 600 records in a combobox
is far too many to have to scroll through.

 

[Brendan Reynolds]

See Allen Browne's article 'Combos with Tens of Thousands of Records' at ...
http://allenbrowne.com/ser-32.html

 

[Albert D.Kallal]

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