Access List Box Size Limits

  • Thread starter List box size limit
  • Start date
L

List box size limit

I am displaying a list box in a form that runs off a query, the list box
should display 146,600 records in the list box, however it seems to stop
somewhere around the middle of the list. Is there a size restriction for a
listbox? If so is there a way to increase the list box size?
 
D

Douglas J. Steele

If I recall correctly, the limit is 65,535. This is a hard limit, with no
way to override it. (I seem to recall it's due to the fact that they use a 4
byte field as the internal counter for row number)

On the other hand, that's far more records than is reasonable to expect
users to choose from. Consider some alternative interface to allow the users
to fine-tune what's presented. Allen Browne shows one way to do this (for
combo boxes) at http://www.allenbrowne.com/ser-32.html
 
Top