Combobox number of records

GuidoNTS

Registered User.
Local time
Today, 19:19
Joined
May 27, 2008
Messages
13
Hello

Can someone tell me if I can see more than 65535 records in a combobox using Access 2010. In Access 2003 that is not possible, but I was told that this is possible in 2010.
My table contains more then 80000 records.

Thank you.

GuidoNTS
 
For efficiency I would deter from trying to populate a combo with so many records. How many columns are you using and is the bound column indexed?
 
The bounded column is indexed. I use three columns.

GuidoNTS
 
Is your rowsource based on a query or a table? Query is better.
 
Are you using 2010?
Has your query got 80k+?
Does it work?
 
I use 2010.

The query gives me 80125 records.


GuidoNTS
 
So has that not answered your original question?
 
NO,

Because I just can see the list until number 65535, the records from then on they are not displayed in the comboboxlist

GuidoNTS
 
Then the answer is No. If you can only see a subset of the query then the previous limit still applies for 2010.

Again though 80k+ items in a combo is heavy duty on resources.
 
There's perhaps one or more selection criteria you can set within your form to help cut the combo box records down to more manageable proportions?
 

Users who are viewing this thread

Back
Top Bottom