65536 limitationon drop down?

[dzirkelb]

I have a drop down that displays all of our inventory master data using access 97...when the query is run that houses the data, it displays 66794 records. When I go to the drop down, it stops displaying at the 65536 record...it appears there are a bunch of white spaces after that. Anyone know why this is or how to correct it?

 

[RuralGuy]

I believe that is the limit of a ComboBox! It has to do with the ComboBox's ability to keep track of ListCount and ListIndex.

 

[RuralGuy]

MVP Allen Browne has some code that has the side effect of cutting down the number of records returned.

 

[dzirkelb]

I am moving the data from an access table over to an sql table this weekend...is the limitation on the comob box itself or is it an access table limitation? I'm hoping it is an access table limitation and moving it will fix the problem.

 

[RuralGuy]

The limitation is in the ComboBox control!

 

[RuralGuy]

If you look at Allen's code and don't start populating the control until the user has typed a few characters (or even one), I think you may be satisfied with the results.

 

[dzirkelb]

ya, that code will probably solve my problem...I was just hoping I could get by without having to implement it

I should be able to grind my way through it and get it to work...thanks!