access to available items in combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Masoud - 06 May 2007 07:44 GMT

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.

Reply to this Message

Peter Hibbs - 06 May 2007 09:17 GMT

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.

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

Reply to this Message

Douglas J. Steele - 06 May 2007 12:34 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

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

Reply to this Message