Combo box

[citychap26]

Hi Guys,

what is the maximum number of rows you can load into a combo box? I am using row source type "Table/Query" and the rowsource is a select query.

The table contains 160k rows!

Cheers

SK

 

[AccessGuruCarl]

citychap26

The table contains 160k rows!
Do you mean records....

The combobox should display all the records...
And whatever rows/columns you selected to view.

Drop a new combobox on the form, make the wizard button is depressed... the select the query, then the columns you want displayed. Usually this is 1 or 2 fields....

Then edit the combobox properties, List Rows to display how many records to display when a users clicks it. The default is 8

Hope this answers your question?

Carl

AccessGuruCarl
Programmers helping programmers
you can't find a better site.

 

[MajP]

SK,
With that many records, I would think that it may be hard to find the desired information depending on what the information is.
If interested I recently wrote a faq ( faq702-6304 ) that filters a combobox as you type into it. So suppose you have names and want to filter on last name, but do not know the exact spelling. If you type in "J" it will filter the list to only those with last names beginning with "J". If you type "Jo" only those beginning with "Jo", etc. May be helpful.
It is a class module, and requires no code modification to work on any combo box. If this functionality would be helpful I would be interested on performance issues with that big of a recordset.