Increase Combo List Limit

[feinj]

Is there any way to increase the limit on the number of records that can be listed in a Combo Box on a Form?

 

[Mr. B]

Exactly what limit are you talking about? Pleae explain. The only limit that I am aware of it the limit of the records returned by the record source for the combo box.

 

[boblarson]

The only limit that I am aware of it the limit of the records returned by the record source for the combo box.

The ROW SOURCE has a maximum of returning 65,535 rows. If you need more than you will likely have to use a combination of controls, either combos or textbox with combo to first cut it down a bit so it will fit.

Also, when you do have so many in the combo, it isn't necessarily going to be able to scroll to them. You can start typing to get the first few characters, and then do the drop down.

 

[feinj]

My understanding is that a Combo Box is limited to something like 65,000 records. My record set contains almost 250,000 records.

When I increased the number of records for list, the comb box stopped the autofilter at record number 65,533.

 

[boblarson]

My understanding is that a Combo Box is limited to something like 65,000 records. My record set contains almost 250,000 records.

When I increased the number of records for list, the comb box stopped the autofilter at record number 65,533.

Yep, that's pretty much the limit. So, you need to do what I wrote above and do some "pre-filtering."

 

[feinj]

Ok Bob. thanks for the help