Combo box record limit of 65k

[Doug]

I am running into an issue with a combo box in an Access 2002 .adp where I
have more than 65k of records. Are there any easy workarounds for this issue?

Thanks,
Doug

 

[Ken Snell \(MVP\)]

You would need to add a second control that would allow you to enter some
filtering criteria for the combo box so that its row count will be less than
the 65536 rows limit.

I have an example database that shows how to "combine" a textbox and
combobox for seamlessly switching from textbox (where you begin to enter the
starting character(s) that you want) to a combobox that displays the
filtered list:
http://www.cadellsoftware.org/SampleDBs.htm#CombinedTextComboBoxes

Arvin Meyer (MVP) has some sample databases that you can download for
another approach. See ExpandingSearch97 and ExpandingSearch2K at
http://www.datastrat.com/Download2.html

Allen Browne (MVP) has another approach at his website:
http://members.iinet.net.au/~allenbrowne/ser-32.html

 

[David W. Fenton]

I am running into an issue with a combo box in an Access 2002 .adp
where I have more than 65k of records. Are there any easy
workarounds for this issue?

Use a different kind of control or more than one control, since
anything over 100 records in a combo box is insane user abuse.