Printable View
I want to load approximately 5000 names (from an Access table) into a combobox. But it takes forever!!!! Is there any way to speed this process up?
I am using the "combo1.additem" method. I need the combobox because I can type a few letters of a name, and it will automatically scroll down to that name. Is there some other way to accomplish this, so that I don't have to use a combobox?
i think that the time-lag is probably more related to the retrieval of the data from the database rather than the AddItem method...
could you paste your code where you retreive the data and fill the combobox?
I don't know whether it is quicker but you could try the data combo control. 5000 is a lot of records for combo box I personally would use some kind of lookup form with more options for the user to be able filter etc.
Or
a text box to allow the user to enter the text and use the validate event to see if it is valid, if not make the forecolor red if it is then make bold and underline. This way you can just issue a short SQL statement to validate the users entry.
combobox should be fine.. it's not a bound control either :)