Maximum Records Displayed in Combo Box = 65536?

[Blake]

I can't find this in the Help dialogs, but some simple experiments suggest that the maximum number of records I can display in a combo box is 65536 (i.e. 2^^16). It happens that my table has many more records than that. Is there a way to extend the number of records displayed in a combo box? I tried binding the combo box to a query and fiddling with the query's MaxRecords property, but that didn't work.

Regards, Blake R. Wiggs

 

[boblarson]

This may be a silly question, but why would you want to have over 65,000 choices in a combo box?

There has to be a better way to accomplish what you need that doesn't require:
1. the user to have to navigate through that many records
2. to take the time to populate such an extreme number

Can you break it down into pieces?

In other words, can you use other controls or other combo boxes to narrow down the focus of the combo box?

Let me know if that isn't clear and I'll post more.

 

[Blake]

Thanks. I've pondered the problem and decided that you're right. My initial reason for wanting the combo box was that the recordset (invoice numbers) is fragmented. By using a combo box, I could have forced the user to pick a valid number from a list. But, I can validate a number entered via text box & display an error message if required.

Regards, Blake R. Wiggs