Help with Combo box not displaying all

  • Thread starter Thread starter IreneJ
  • Start date Start date
I

IreneJ

We have 107,000 addresses in our database. I have a
combo box on the main form to allow staff to bring up the
address when they start typing. Problem appears that
only 1/2 of list is showing. If they ask for an address
in the first half say of the database the address with
come up and they can click the dropdown the address will
be there and they can select the specific one they want
(different unit nos). If they search for an address that
is in the bottom half of the database, they can still get
the address to come up on the search box but when the
click the dropdown the address is not there highlighted
for them to pick from. Is there some kind of limitation
that I need to be aware of.
Thank you for any help.
Irene
 
Is there some kind of limitation
that I need to be aware of.
Click to expand...

Yes: a Combo Box is limited to display 65536 records, no more.

You may want to have some code to "pre filter" the combo box's Row
Source query to be under that limit.
 
Back
Top