Combo Box Cutting off Records

  • Thread starter Thread starter john2171
  • Start date Start date
J

john2171

I have a combo box that's pulling from a table via ODBC
(table is on MS 2000 SQL server). This table has over
70,000 records in it. I'm pulling two fields, a name field
and an account number field, where the name filed
corresponds to a person's name, which can be listed
multiple times because a person can have multiple account
numbers. The combo box is sorted in ascending order by
name, and what happens is, if I type anything past the
letter "T", the box will stop at letter "T" and it won't
show any names past the letter "T", anything below "T"
will work fine...

Why is this happening?
 
Hi John,
I'm not positive, but I would guess it is a limitation on how many records a
combo box can hold. 70,000 is a lot of records...
Assuming you will always type the first letter to begin your search, you
could try this:
Don't pre-populate the combo box. Wait until you type the first letter and
hit enter, then have the combo box populate with only the records that begin
with that letter or letters.

Andy
 
Back
Top