Help, listbox doesn't support 50,029 entries.

[AndyK]

Standard listbox control can't handle 50,000 entries. What can I do? and I don't want to split the database into 2 listboxes. Thank You.

[dcaillouet]

Some suggestions:

1. Have a combobox with A, B, C,...Z, 0, 1...
When a user selects a character, only show items in the listbox that start with that character. This will break listing into much smaller groups. (Personally if I ever encounter a listbox with 50k+ entries, I'm not going to look through it for anything.)

2. I can modify the properties of my Sheridan grid so it look exactly like a listbox and then bind it to an ADO recordset. As far as I know, there isn't a limit to the number of records. Maybe you could do the same and use a different control instead of a listbox.

3. Rethink your design so you don't have to put 50,029 entries in a listbox.