MS Access combo box - limited lookup limit
Posted on 2004-08-11
I have a combo that searches a specific field in a table of several thousand records. The user types in the first couple of digits and the combo begins to auto-select. My problem occurs when the user requests a record that is "way down" the list, whereby the auto-select seems to reach a limit and stop. I have, therefore, had to set the combo to "Limit To List = No", where ideally I want to "Limit To List = Yes". This is because other fields are propogated automatically upon record selection. Is there a hidden natural limit within Access that can be turned off, or is there a property somewhere, where the number of records to be read can be defined?
Thanks in advance.