List/ComboBox-65536 Max Lines??

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

One of the projects I am developing using Access 97 has
over 172,000 records in one table. Using a 'List Box' on
the form to display pertinent fields for a user
to 'select' which record to view, I've found that
the 'display' stops at record #65536, although the 'List
Box' seems to have MORE lines (albeit BLANK) below the
last displayed line.

It seems to me I've read somewhere that this is a
maximum 'limit' for these control types. If that's true,
is there a 'way around this', accommodating the large
record count, and still use that type of control? If
so, . . . how? Or, would I be better served to use
a 'form' (or 'subform' within a 'form') to display all the
records and allow the user to make a record 'selection'
from that?

Thanks in advance.

Gary
 
Please IGNORE this question as I found the SAME one in
another newsgroup on "access.forms.programming" (around
Sept 12, 2003). Furthermore, I mistakenly put '65536',
rather than '65535'!

My apologies,
Gary
 
That's the limit. If you think from the users' point of view, that's a huge
list to look at. It also slows your database application down as you are
pulling a huge amount of data just to populate the list.

Suggest you have a set of cascaded ComboBoxes or ListBoxes where selection
in the first Combo/ListBox will narrow down the number of rows in the 2nd
Combo/ListBox.

See the technique in The Access Web article:

http://www.mvps.org/access/forms/frm0028.htm
 
Thanks, Van, for your helpful comments and the reference
to the 'Access Web article'. I'll check it out.

Gary
 
Back
Top