ComboBox list isn't complete, gets cut off at 10000 items...

  • Thread starter Thread starter Maury Markowitz
  • Start date Start date
M

Maury Markowitz

I have a combobox in a subform that's limiting the contents to 10000
rows. I have changed the recordsource on the form to 32000, and the
setting in Options for list length to the same number. No luck, it's
still cut off at the same place. Any ideas?

Maury
 
Well, even 10,000 rows in a combo box is probably about 9,500 more than you
should have for usability. What's the RowSource of the combo box? Assuming
it's a query, does the query return the expected number of rows?
 
The query returns about 21000 rows, but only the first 10000 are
displayed.

Yes, you can do this in a combobox, it pages in as required. I use the
same popup in another ADP, and it works fine there with all the rows
being displayed. There must be a setting somewhere I'm forgetting to
flip.

Maury
 
The query returns about 21000 rows, but only the first 10000 are
displayed.

Yes, you can do this in a combobox, it pages in as required. I use the
same popup in another ADP, and it works fine there with all the rows
being displayed. There must be a setting somewhere I'm forgetting to
flip.
Click to expand...

ADPs (by default) never return more than 10000 rows. It's a setting in
options somwwhere.
 
I didn't see the beginning of this thread, an adp has a default record limit
of 10,000, which you can change.
 
Back
Top