Is there any method to change the number of autocomplete values listed when using an autocomplete parameter?
As an example I have a report that list metal alloys, and if I type FE in the autocomplete box for the report I have a choice of 20 results. however if I run the autocomplete query directly using the following SQL Statement:
SELECT Code FROM Example.dbo.tblStockFamily WHERE Code Like 'fe%' ORDER BY Code
This would return in excess of 200 rows.
Now obviously I may not want the full 200+ rows to return, but is there an option to increase the default of 20?