Combo box record limit of 65k

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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?
Click to expand...

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