Max number of items in Combobox

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

Guest

Hello
There appears to be a maximum limit of 64k items in a combobox list. Is this
correct? And is there a method to override this limit?

I know it is normally a large enough number, but in my application for a
storage warehouse, I am using a combobox to enable selection of a valid
storage box number and there are currently 66233 boxes!
When the user presses Ctrl-End to go the bottom of the list, it displays the
65536th row. It will still allow entry and validation of box numbers beyond
this limit when a valid box number is typed in, but it cannot display these
box numbers.

Any ideas please?

Regards
Richard Corner
 
Brendan

Many thanks for your suggestion.
Unfortunately, my box numbers are not of a fixed number of characters and
not filled with leading zeroes, so I can't use the technique in the article
you referred to.
The article does give me some pointers for which way to go though.

Richard Corner
 
Allen's technique has no such restriction, Richard. I just tested it with a
list of Irish counties and postal areas, which follow no fixed pattern at
all. It works just fine.
 
Back
Top