Access 2003 Combo Box Table Look Up Display Limit?
Posted on 2013-01-29
I have an access data base that has street addresss that the user can seach in a query.
The street addresses are stored in an Oracle database.
I am using a form that has a combo box linked to a Access query that returns those addresses from the Oracle database. I have Auto Expand set to "yes'' and Limit To List set to "Yes".
The problem I have is that as the user types in the address, the drop down list of choices works only for the 1st 60,000 records. Then the display of choices stops. The user can still type in the address after that limit and it does prefill what it thinks the user wants, but the display is no longer focused in that area or choices.
Is there a limit to displaying records in combo box? Is there a work around or am I missing some kind of setting that is needed when the amount of choices is very large?