combo box inquiry

J

JohnE

I am seeking info on the combo box. I realize there is a limit to the number
of items that can be listed. But what I am wondering is at around how many
items will the combo box slow down (ie 500, 1000, 5000)? What is a rule of
thumb, so to speak? Just wondering as our access db will be getting an
infusion of about 3000 more clients by end of year. So I should be
considering an alternative method of display the client list.
Thanks for any feedback.
*** John
 
V

Van T. Dinh

ComboBox can have up to 64K rows in the RowSource. However, that's a lot
for the user to select one from.

Sort the names alphabetically and use AutoExpand on the ComboBox. Tell the
user to type the first few letters and they should get very close to the
name he/she wants.

You may want to consider in the future to use a set of "cascaded" ComboBoxes
where the user select the first character for the name and the second
ComboBox is filtered to show only the names with the same starting
character. You can use a Label or a TextBox instead of the first ComboBox.
 
Top