AndyK
September 23rd, 2001, 07:38 PM
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.
Click to See Complete Forum and Search --> : Help, listbox doesn't support 50,029 entries.
dcaillouet
September 24th, 2001, 07:22 AM
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.
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.
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.
Copyright Internet.com Inc., All Rights Reserved.