Combo box Limit

[Joey]

Hello everyone,

I have a drop down combo box list in Access 97 that is supposed to
contain all the values based on a query; however, certain values are not
showing up in the combo drop down list. The query which is the source
of the combo box drop down list has over 70,000 values but not all
values are showing up. The query is a simple query and it is working
fine. Under Tools -> Options -> Edit/Find tab the "Don't display lists
where more than this number of records read" set to 30,000; however, I
cannot significantly increase this value. Is there any way to ensure
that the combo drop down list will contain all 70,000 values (and many
more in the future)?

Thanks,
Joey

 

[Rick B]

Not sure that I would ever want a combo-box to display more than a hundred
or so records. What on Earth are you pulling to this box? Why are you
doing it in a combo-box? With that many entries it seems unlikely the user
would need to pick items from a box!

Can you make it cascading? In other words, have two combo-boxes. The first
one lets the user specify a filter that is used in the second.

For example, if your combo box contains the name of every city in the
united states, you should have another one that lists all the states. When
user picks a state, then the city box will only show cities in that state.

Post back more details if you want help. My general thought here though is
that a combo box is not really designed to pull that many entries if it is
to be of any use. A "find" field would be of more use.

 

[Jesper Fjølner]

Is there any way to ensure

that the combo drop down list will contain all 70,000 values (and many
more in the future)?

As I recall the limit for items in a combo is right around 65.000

 

[Van T. Dinh]

Yep. 64K rows.

--
HTH
Van T. Dinh
MVP (Access)

As I recall the limit for items in a combo is right around 65.000

 

[Joey]

I'm placing unique part codes in the combo box. They can't be further
subclassed so I can't make it cascading. I'm using a combo box because
as the user types the part code (a weird combo of numbers and letters)
the list moves to that part code prefix so the user only has to type in
a few characters then click on the part on the list instead of typing
the whole part code. Is there a way to accomplish this without hitting
the 64k limit? Or is there a better approach?

Thanks,
Joey.

 

[Jesper Fjølner]

Is there a way to accomplish this without hitting

the 64k limit? Or is there a better approach?

There're probably a couple ways you could go, but one way I can think of to
decrease the number of records in the combo could be to have a textbox just
above the combo.
The combo should initially be empty.
In the textbox the user could start entering 1, 2, 3 digits/letters of the
part number.
The first time a letter/digit is entered in the textbox the combo is filled
with the part numbers starting with the content of the textbox.
On additional entry in the textbox the combo's rowsource could continously
be updated and subsequently hold less and less records as more is entered in
the textbox.
That could keep you going as long as you have less than 64K records
beginning with the same letter. When that happens you must wait for 2
digits/letters to be entered before you fill the combo. It's unlikely you
hit the limit with something like that.
Does any of this make sense?

Jesper Fjølner
Denmark

 

[Brendan Reynolds]

See Allen Browne's article 'Combos with Tens of Thousands of Records' at ...
http://allenbrowne.com/ser-32.html

 

[Guest]

I could use your suggestion below, but do not know how to get the combo box
to fill in as text is entered into the text box?