Combo box loading

[Boon]

Hi,

I am using a combo box in my form. The combo box links to the list of
numbers from one table. The list is a number from 1 to 1000.

When I open the form in "form view", the first time I click on combo box and
scroll down, the value doesn't scroll along. But after I scroll it to the
very buttom of the list, the value scroll along smoothly. Is it a way to
make this happen right at the first time I click the combo box?

Thanks,
Boon

 

[Peter Hibbs]

Boon,

In the Form_Load event of the form enter this :-

Dim x

Combo1.Requery
x= Combo1.ListCount

where Combo1 is the name of your combo box control

HTH

Peter Hibbs.

 

[Boon]

Thank you Peter,

Do you know how many items can be in a combo box? I noticed that it can
have only 63553. My list has about 1000000.
What should I do?

Boon

 

[Douglas J. Steele]

There is no way around the limit for the built-in combo box.

See what Allen Browne has at http://www.allenbrowne.com/ser-32.html for one
approach, or look into 3rd party products such as TList from Bennet-Tec
http://www.bennet-tec.com/btproducts/tlist/tlist.htm