Combo Box Doesn't Display Entire Recordset

[mstorer]

Is there a limit to the number of records a combo box will display?

I have a combo box that displays, via a query, all of the records in a table. There are about 67,000 records in the table but the combo box won't display past about 65,500 in the drop down list. The drop down list displays customer name in alphabetical order and won't display past the middle of the 'W' names.

With the Auto Expand enabled, it will fill in the name (i.e. Zebra, Inc.). The user simply cannot select it from the menu.

Thanks for any insight.

- Matt

 

[livvie]

Is there a limit to the number of records a combo box will display?

I have a combo box that displays, via a query, all of the records in a table. There are about 67,000 records in the table but the combo box won't display past about 65,500 in the drop down list. The drop down list displays customer name in alphabetical order and won't display past the middle of the 'W' names.

With the Auto Expand enabled, it will fill in the name (i.e. Zebra, Inc.). The user simply cannot select it from the menu.

Thanks for any insight.

- Matt

Is there a Max Records limit set on your query or form ?

 

[Rich]

There is a limit of appr. 64k records for combo boxes, you'll have to use cascading combos to break it down say from A-K L-Z

 

[mstorer]

Thanks for the insight. Rich, I figured that there may be some limit. I hadn't thought of breaking out the combo boxes into parts of the alphabet. Thanks again for the suggestions.

- Matt