Limitation On Combo Box

[TJLearn]

Hi,

I can't figure out how to make it work. I need your help.

I am using Access Project. The problem I have right now is my search combo box doesn't show all borrowers because the number of Borrowers exceeds the maximun number that can be displayed on the combo box. Is there a way to make it show all of my borrowers? All of your helps will be very appreciated!

 

[SteveR77]

A combo box has a maxium of 65,536 rows. Ideally though the list of a combo box should be 50 to 100 rows based on performance.

Steve

 

[Steve101]

A simple trick I use to overcome this limitation is to have a text box and a List box working 'in tandem'. The user enters characters into the text box; an OnKeyPress event in the text box then feeds the current text box value into the Criteria part of the selection clause of the RowSource of a ListBox (using the LIKE operator with a % wildcard concatenated to the text field value), and requeries the ListBox (the list box could be a combo).

This results in progressively smaller result sets being made available to the user as the search criteria are qualified. Works well; especially with large data sets.

Make sure though that your selection criteria is properly indexed.



Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)