Combo box data items

[N]

Hi

Is there a limit to the amount of rows that can be
retrieved into a combo box? We have a basic SELECT C1, C2
FROM TABLENAME select that fills the combo box with data
and it does not seem to want to read beyond a certain row.
I think that the number of rows it reads is 65675

Any clues, please help.

Thanks
N

 

[Marshall Barton]

Is there a limit to the amount of rows that can be
retrieved into a combo box? We have a basic SELECT C1, C2
FROM TABLENAME select that fills the combo box with data
and it does not seem to want to read beyond a certain row.
I think that the number of rows it reads is 65675

Yes, there is a limit and it's 64K.

That's an awful lot of records for a combo box to process,
isn't there something about what you're trying to accomplish
that can be used to dramatically reduce the number of
records. A common approach is to use two (or more) combo
boxes, one that picks a "category" and the other that only
shows the items in that "category".