I have a combo box with 60 000 + re

[Trainingjason]

I have a combo box with 60 000 + records to display. As the combo box only displays 64*1024 records. In otherwords approximately 65000 records.

We are soon going to add another 20000 records which will take us past the limit of displaying all records in the combo.

The problem is that the value can be typed in the combo box, but in the drop down the value can not be seen. This is important to our business to see the surrounding values.

Our initial thoughts were adding an activex control for a combo box for more than 65K records.

Any advise appreciated.


Trainingjason

 

[Ed2020]

My advice would be to add some form of filtering to the combo-box so it doesn't have to display all 65000 records at once or to use a different control.

Combo-boxes aren't designed to display this number of records at once.

Have you considered using a listbox instead?

Ed Metcalfe.

Please do not feed the trolls.....

 

[Trainingjason]

The options I have considered so far

1) Text box over a combo, type first 2 characters then display in combo

main issue, what happens if user decides to rewrite previous character

2) Look for activex control that has over 64K of data


Jason

 

[SgtJarrow]

I have to agredd with Ed on the list box...

My recommendation would be a text box in which the user can type....whatever the user types filters the list box down. The user then selects the item in the list box. If the user needs to change the spelling (filter), they change it in the text box and the list box is updated.

To make things work a bit more effieictlly (as a continuous updating of a list box of this size will take time), you simply use the afterupdate event of the textbox, and requery the list box, which is set to filter Like the value in the text box.

****************************
Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com

 

[MichaelRed]

w/o some idea of the 'content' format of the data, it is difficulat to provide specific recommendation. BUT (ye olde INEVITABLE butt), condider a set of cascading combo boxes, where a First combo box simply sets 'prefix' character(s) for succeding combo box(es).

Another option coule be the old rolodex approach for the prefix char(s).



MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[Genimuse]

I think mstrmage1768's advice sounds pretty good. Put the filtering change in the OnChange event of the textbox and refilter the listbox based the contents of the text box.

When you say the users need to be able to see the surrounding values, would the values that are similar alphabetically be enough, because this solution would do that.

Oh, and you might be able to speed up your application if you display nothing in the listbox while the trimmed value of the text box is null (so that all 85,000 records don't need to be displayed at the beginning, and only after the first character is typed does anything show up).

 

[Genimuse]

(Wish you could edit messages here...) In my second sentence I meant to say "If the users need to have the list updated constantly then put the filtering change in the OnChange event...".