ListBox Limitations

  • Thread starter Thread starter Horace
  • Start date Start date
H

Horace

Hello everyone . . . . .

What are the limitations on Rows & Columns that can be
displayed in a listbox? Particularly when using query as
the rowsource . . . .

I have a situation where the number of rows increases as I
decrease the number of columns.

I've deleted and reconstructed the listbox several times
with no change in results.
 
Hello everyone . . . . .

What are the limitations on Rows & Columns that can be
displayed in a listbox? Particularly when using query as
the rowsource . . . .

I have a situation where the number of rows increases as I
decrease the number of columns.

I've deleted and reconstructed the listbox several times
with no change in results.
Click to expand...

I believe you're limited to 65536 rows, and 10 columns (I'm not quite
certain of the latter).

Could you explain what you mean by the "number of rows increases
as..."? What's the RowSource query? What about the Column Widths
property?
 
John Vinson said:
I believe you're limited to 65536 rows, and 10 columns (I'm not quite
certain of the latter).

Could you explain what you mean by the "number of rows increases
as..."? What's the RowSource query? What about the Column Widths
property?
Click to expand...

The limit has always appeared to me to be some amount of data. (64k) If a
combo box (not tried with list box) shows just a last name it will display
more rows than if it contains last name and telephone number.
That is, if I enter Jo, the list will show the rows with jo*, etc.

Along about the letter T, entering "To" will not show Thomas etc.
If I enter the full name Xsomething, the query will return this person.
With 45,000 odd records in the table it stops at about the "T" in my case.
When I reduced it to about 16,000 the whole table, Ts and all show.
 
Back
Top