VB combobox max listcount problem.

[Albela]

Can someone tell me how to populate huge number of items in a combobox. What is the limit. I am trying to put in a mere 7000 rows and getting an error 2176 - Value for property too long.

Thanks.

 

[KLin]

It's not the number of rows that's the problem. It's the data length of one of the rows that is giving you the error I believe.

EDIT: a combobox can support up to 65535 rows FYI.

 

[tfinch2]

a combobox can support way more than 7000 items. i haven't used VB in so long but i do remember that. look elsewhere for your error

 

[Albela]

Could this be beacuse I am using the value list option for the combobox.row source type ?

The data is just 50 chars in length and everything seems good on that part.

 

[tkdkid]

A combobox with 7000 items would be hard to use, don't you think?

 

[jparnell]

What kind of data are you putting in? Maybe there is a better solution...like tkdkid said, it would be hard to use i would think

 

[Albela]

I am trying to put in all possible "Skills" into the combo box. User would have to select whatever he has.

Right now we have combobox that is linked to column in the table holding those values directly (MSAccess). I am trying to use ADO and populate the values from the table using the "Value/List" option for the recordsource property.