combo box record limit (a2k)

Topic

New Reply

I have a combo box with 73,000 records. Only the first 65,000 will display in the drop down. Is there a size limit to the combo box recordset? What’s a good strategy for getting those last 8,000 records to display?

E

Reply | Quote

Replies

A combo box can contain 2^16-1 = 65,535 elements, and there is no way around this limit, it is a technical restriction. But long before that, it will become virtually unusable. You should replace the one combo box by two or three cascading combo boxes, in which the user can successively narrow down the selection. Search this forum for cascading combo, or look at ACC2000: How to Synchronize Two Combo Boxes on a Form and ACC2000: How to Create Synchronized Combo Boxes.

Reply | Quote

The combo box is a zip code lookup. Typing the zip pulls up the city, state and country in separate text boxes. The only time the multiple column display of the combo box is needed is when two cities have the same zip and the user needs to choose between the two. Is it possible/practical to create a command button to reverse the sort order of the combo box so that the 8000 records that don’t display in ascending would in descending rather than creating a cascading combo boxes?

E

Reply | Quote

You can change the Row Source of the combo box in the On Click event procedure of the command button. Either prepare two queries, one that returns the zip codes in ascending order, and another that returns them in descending order, and set the Row Source to the name of the appropriate query, or set the Row Source to an SQL statement that returns the records in ascending or descending order.

Reply | Quote

works like a charm

Reply | Quote

works like a charm

Reply | Quote

You can change the Row Source of the combo box in the On Click event procedure of the command button. Either prepare two queries, one that returns the zip codes in ascending order, and another that returns them in descending order, and set the Row Source to the name of the appropriate query, or set the Row Source to an SQL statement that returns the records in ascending or descending order.

Reply | Quote

The combo box is a zip code lookup. Typing the zip pulls up the city, state and country in separate text boxes. The only time the multiple column display of the combo box is needed is when two cities have the same zip and the user needs to choose between the two. Is it possible/practical to create a command button to reverse the sort order of the combo box so that the 8000 records that don’t display in ascending would in descending rather than creating a cascading combo boxes?

E

Reply | Quote

A combo box can contain 2^16-1 = 65,535 elements, and there is no way around this limit, it is a technical restriction. But long before that, it will become virtually unusable. You should replace the one combo box by two or three cascading combo boxes, in which the user can successively narrow down the selection. Search this forum for cascading combo, or look at ACC2000: How to Synchronize Two Combo Boxes on a Form and ACC2000: How to Create Synchronized Combo Boxes.

Reply | Quote