Combobox control max size

[DeMoN]

Hi.

I'm developing a VBA application, and I have to store into a combbox more of
10.000 records.

The problem is that combobox only show 10.000 records, and I'm losing
information.

There's any property into the combo box to allow to show more tht 10.000
records.

Any other idea or suggestion??

Thanks.

 

[Jonathan West]

I suggest you ask yourself this question

"How on earth is the user supposed to make a meaningful selection between
more than ten thousand options expressed in a simple list?"

The answer of course is that the user isn't going to be able to. Therefore,
you need to find a way of breaking the list down into more manageable
chunks. How you do that depends on your application, but I would recommmend
that you divide in terms of some category that is meaningful to the users,
so that they will be able to find the item they want in the subjest they
expect.

 

[DeMoN]

I think the same as you... but our users says that they don't know the group
name of the option they want to select... and they want to be able to select
the item from a list with ALL of the items availables.

I think we should filter by the parent group, but that is no my decision...

Thanks John.

 

[Jonathan West]

I think the same as you... but our users says that they don't know the
group
name of the option they want to select... and they want to be able to
select
the item from a list with ALL of the items availables.

I think we should filter by the parent group, but that is no my
decision...

If the listbox can't manage it, then the design is going to have to change,
either to split the list, or to restict it to under 10000. There isn't
really a third choice.