Listview Limits

  • Thread starter Thread starter Damien
  • Start date Start date
D

Damien

Is there, or has there ever been a limit to the number of
records you can show in a ListView control?

Thanks


Damien
 
Damien

Prurient interest, or practical consideration? Undoubtedly there is an
absolute upper limit (check Access HELP on "specifications" for the
theoretical value).

But from a practical standpoint (i.e., how much delay your users will stand
for), you probably don't want to have a listbox with more than 10's of rows
(subject to debate - ?100's of rows?).

If you have a LARGE number of rows for users to consider, consider other
approaches. You can narrow down the list by providing initial screening
criteria. You didn't say what your data domain is, so here's a (probably
unrelated) example:

If you are searching for addresses, use a combobox to select State/Province,
and a second to select City before listing all addresses related to those
two selection criteria.
 
Jeff,

I'm doing some User Acceptance Testing (UAT) and the
developer has blamed one of the bugs on the ListView only
being able to accept 32,000ish records. I know this not
to be true, but before I call him a liar, I'd like to know
if there's been a limit historically, eg the last version
of the ListView, or does a limit kick in if you have too
many columns, so the total number of 'cells' in > 32,000.

I agree that in normal User Interface rules, you wouldn't
expect to see tens of thousands of records, but he's
creating a batch utility, and this is the method he has
chosen.

Thanks


Damien
 
AFAIK, the number of records that can be presented in a listbox is limited
by the value that can be held in an integer. Integers range from -32,768 to
32,767, so the limit is either 32,767 or 65,535 (I just don't remember
which)

However, since that's far more records than can reasonably be presented, I
think it's fair to say that the bug is in the program design.
 
That's ListView. List. View.

-----Original Message-----
AFAIK, the number of records that can be presented in a listbox is limited
by the value that can be held in an integer. Integers range from -32,768 to
32,767, so the limit is either 32,767 or 65,535 (I just don't remember
which)

However, since that's far more records than can reasonably be presented, I
think it's fair to say that the bug is in the program design.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)






.
 
Back
Top