access to available items in combo box

M

Masoud

in my combo box there are around 15000 items, but for accesing to all of them
i have problem because i have to push the arrow bottom of combo box alot and
it takes a lot of time.
Thanks.
 
P

Peter Hibbs

Masoud,

In the Load event of the form enter the following code -


Dim lngCount as Long

ComboBox.Requery
lngCount = ComboBox.ListCount


Substitute the word ComboBox for the name of your combo box control.

HTH

Peter Hibbs.
 
Top