Information générale
Catégorie:
Gestionnaire d'écran & Écrans
You may want to use another control than the ComboBox. It is normal to experience slowdown with a big list.
IMHO, ComboBox should be limited to no more than 100-500 items. Do you really want to scroll a 2000 items list to find the item you want?
>I have a form with a number of controls (comboboxes and listboxes) which is used to populate a table (that is control-source for these controls). PROBLEM is that form's response is VERY slow because of size of ROWsource for two comboboxes on form. (Rowsource is a table of about 2,000 records.) Slow behavior exhibits both upon creation of form and upon interactive drop-down of combobox list.
> The rowsource table is included in the forms dataenvironment, and is indexed (regular) by the fields used as rowsources in the combobox. I've tried using rowsourcetype-6 (fields) and specifying the to-be-displayed fields in the combobox's rowsource property, and I've tried rowsourcetype-3 (SQL-select) and selecting to a cursor in the rowsource property; both yield similar, SLOW results. There is no filtering involved -- all records are being shown.
> Users will need to use the combobox control every time they use the form, so a workaround suggested in MS' DevGuide -- viz., setting the rowsource dynamically in the gotfocus event, rather than statically -- wouldn't be of much use.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement