Max items in controls: list box; combo box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. What is the maximum number of items that can be listed in a combo box?

2. What is the maximum number of items that can be listed in a list box?

3. If one needs more that the max, what does one do?

Thanks much in advance.
 
XP said:
1. What is the maximum number of items that can be listed in a combo box?

2. What is the maximum number of items that can be listed in a list box?

3. If one needs more that the max, what does one do?

Thanks much in advance.
Click to expand...

1. 65535

2. Ditto (the list component of an Access combo is actually a listbox)

3. Create more than one control eg:
A combo filtered for A - G
Another filtered for H - N
etc.
 
XP said:
1. What is the maximum number of items that can be listed in a combo box?
Click to expand...
65536 rows

2. What is the maximum number of items that can be listed in a list box?
Click to expand...
65536 rows


3. If one needs more that the max, what does one do?
Click to expand...
The primary way of doing this is to let the user enter some initial
information that will filter the potential list of items to be less than
65536 and then to display the combo box.

I have a sample database that uses a combination of a textbox and combobox
(a class module switches back and forth between them) so that you start to
enter the first character or two of the desired value in a textbox, and it
then becomes a combobox to let you continue the selection.
http://www.accessmvp.com/KDSnell/SampleDBs.htm#CombinedTextComboBoxes

Arvin Meyer (MVP) has some sample databases that you can download for
another approach. See ExpandingSearch97 and ExpandingSearch2K at
http://www.datastrat.com/Download2.html

Allen Browne (MVP) has another approach at his website:
http://members.iinet.net.au/~allenbrowne/ser-32.html
 
Back
Top