Max items in controls: list box; combo box?

[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.

 

[Stuart McCall]

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.

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.

 

[Ken Snell \(MVP\)]

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

65536 rows

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

65536 rows

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

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