<div>
Since you both pointed me to this solution I guess that's the direction I need to go. &nbsp;Thanks and Thank you Grahnam for the explanaination.<br />
<br />
Joe
</div>


Since you both pointed me to this solution I guess that's the direction I need to go.  Thanks and Thank you Grahnam for the explanaination.

Joe

<div>
<div class="content wysiwyg-content">
I have an access data base that has street addresss that the user can seach in a query.<br />
<br />
The street addresses are stored in an Oracle database. &nbsp;<br />
<br />
I am using a form that has a combo box linked to a Access query that returns those addresses from the Oracle database. &nbsp;I have Auto Expand set to &quot;yes'' and Limit To List set to &quot;Yes&quot;.<br />
<br />
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. &nbsp;Then the display of choices stops. &nbsp;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.<br />
<br />
Is there a limit to displaying records in combo box? &nbsp;Is there a work around or am I missing some kind of setting that is needed when the amount of choices is very large?<br />
<br />
Thanks,<br />
<br />
Joe
</div>
</div>


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?

Thanks,

Joe

Access 2003 Combo Box Table Look Up Display Limit?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.