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

[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

 

[Douglas J. Steele]

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?

 

[Maury Markowitz]

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

 

[Dale_Fye via AccessMonster.com]

As Doug mentioned, 10,000 is probably about 9,500 more than you want in a
combo box.

What are you displaying in the combo box? Are they part numbers, names, ???

You might want to consider:
1. adding buttons (A-B, C-D, E-H, ...) above the combo that you would use to
filter the combo box to limit the size of the list:
2. adding a small text field to allow you to enter the first couple of
characters to refine the values in the combo.
3. use a subform instead of a combo box (this can get complicated)

 

[Rick Brandt]

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.

ADPs (by default) never return more than 10000 rows. It's a setting in
options somwwhere.

 

[Paul Shapiro]

I didn't see the beginning of this thread, an adp has a default record limit
of 10,000, which you can change.