Max number of items in Combobox

[Richard Corner]

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 Reynolds]

See Allen Browne's article 'Combos with Tens of Thousands of Records' at the
following URL ...

http://allenbrowne.com/ser-32.html

 

[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

 

[Brendan Reynolds]

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.