combo box

  • Thread starter Thread starter curt
  • Start date Start date
C

curt

Is there a limit to how many items can be presented in a
combo box (Access 2000)? I use a combo box to "find" a
record in a table based on the name. The list in the
combo box only goes through part of the M's, stopping on
the 65,536 name in the query for the combo box. Is that
a hard limit? Any way to get arround it?
 
Curt

That is a very "expensive" combo box (in terms of CPU and RAM). Another
approach would be to make an initial selection/categorization that would
reduce the number of items you needed to present in your combo box.

Perhaps you could provide a little more information about what you are
presenting that comes in a list of over 65 thousand elements?
 
My form is a simple presentation of "leads" (e.g.,
prospects, contacts, etc.) from a table. The table has
about 120k rows. Each rows primary index is an
autonumber field. In many cases, we don't know the "id"
number to find a specific record. We can alway's use
the "find" tool to find a record. But since we almost
always know the lead's name, the unbound combo box (which
is just a query on the table containing the lead id and
lead name, displaying the lead name, but the field value
is the id) is used as a "Find: " prompt that lets us
start typing in the name, select the row from the drop
down list, and then the "after update" event for the
combo box causes the form to fill with the info for the
selected record. Works great, except as I said in my
first message, the combo box only shows up through the
middle of the m's. If I want to "find" a lead with the
name "samurai sam's", I can type in the full name ok and
go to the record, but if I type in an "s" and then use
the combo box to select from the list, it only shows the
last records its populated with which stop in the m's.
Any help?
-----Original Message-----
Curt

That is a very "expensive" combo box (in terms of CPU and RAM). Another
approach would be to make an initial
Click to expand...
selection/categorization that would
 
Curt

As my earlier response suggested, anything you can do to reduce the length
of the list will help. One approach to this is to use 26 "alpha" buttons
(A, B, C, ... Z) as an initial choice.

Another approach is to use a variation on Allen Browne's suggestion -- see:

http://members.iinet.net.au/~allenbrowne/ser-32.html

for an approach that lets you enter the first "n" characters before
triggering the auto-complete feature.
 
Back
Top