Combobox number of records

[GuidoNTS]

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

 

[DCrake]

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?

 

[GuidoNTS]

The bounded column is indexed. I use three columns.

GuidoNTS

 

[DCrake]

Is your rowsource based on a query or a table? Query is better.

 

[GuidoNTS]

I have set the rowsource on a query

GuidoNTS

 

[DCrake]

Are you using 2010?
Has your query got 80k+?
Does it work?

 

[GuidoNTS]

I use 2010.

The query gives me 80125 records.


GuidoNTS

 

[DCrake]

So has that not answered your original question?

 

[GuidoNTS]

NO,

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

GuidoNTS

 

[DCrake]

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.

 

[PaulO]

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?