Combo Box Limitation?

[Song Su]

Access 2003

I created a combo box to find name. Even though I still can type in the box,
the drop down list would not move beyond letter "W". Clicking down arrow
would not help. If I type letter X for example, the searched record show in
the box only but not drop down list.

I have more than 240,000 records in that single table. Did I reach the
limitation of the combo box?

thanks.

 

[John W. Vinson]

I have more than 240,000 records in that single table. Did I reach the
limitation of the combo box?

Went way beyond it, in fact: 65536 rows.

Check out Allen Browne's tip:

http://allenbrowne.com/ser-32.html

In a nutshell, use an unbound combo box and set its rowsource to a subset of
the records after the first one or two keystrokes; e.g. typing "w" will set
the rowsource to a query retrieving only those names beginning with W.

John W. Vinson [MVP]

 

[Song Su]

Good tip. It's nice to know the Access 2003 limitation.
How about Access 2007? Same limitation?

 

[Douglas J. Steele]

AFAIK, it's the same. 65536 is the number of records that can be addressed
using a 2 byte Integer field, and is far more records than you should ever
make a user scroll through!

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)