Limit on entries in combo box

[Koos]

Hi guys

I have a combo box that is populated with a simple query which selects
client ids from a table. However, as of last week the newer client ids are
not being populated to the combo box. So i am thinking that the combo box
has reached its limit for number of entries it can display. Anyone know if
there is a limit and what it is?

We are using Access 97 still and the current amount of entries that the
query returns is 83000 entries.

Thanks
N

 

[Brendan Reynolds]

If I remember correctly, I believe the maximum is 64,000.

For a solution, see Allen Browne's article, 'Combos with Tens of Thousands
of Records' at the following URL ...

http://allenbrowne.com/ser-32.html

 

[Koos]

Thank you

If I remember correctly, I believe the maximum is 64,000.

For a solution, see Allen Browne's article, 'Combos with Tens of Thousands
of Records' at the following URL ...

http://allenbrowne.com/ser-32.html