access to available items in combo box

[Guest]

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.

 

[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.

 

[Douglas J. Steele]

In my opinion, 15000 items in a combo box is far too many to expect your
users to use.

See the alternative Allen Browne has at
http://www.allenbrowne.com/ser-32.html