Limit on entries in combo box

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

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

--
Brendan Reynolds
Access MVP

"Koos" N wrote in message ...
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

Thank you


"Brendan Reynolds" wrote in message
...
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

--
Brendan Reynolds
Access MVP

"Koos" N wrote in message ...
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