Disable Autocomplete for Criteria in Access 2013 Query Designer
Question details
The user wants to stop Access 2013 Query Designer from changing a text criterion into a function suggestion.

- Product
- Microsoft Access 2013
- Device & OS
- not provided
- Scenario
- Entering a text criterion such as A in the Query Designer grid.
- Observed behavior
- Access suggests or changes the entry to a function name such as ABS.
Open the database in Access 2013 and identify the query and text field where you want to enter the criterion.
Enter text criteria in quotation marks
Use quotation marks to identify the entry as a text value rather than a function name.
Access 2013 does not provide a setting to disable this Query Designer IntelliSense behavior. Quoting text criteria is a practical workaround.
In the Navigation Pane, right-click the query and select Design View.
In the Criteria row under the relevant text field, type the value with double quotation marks, such as "A". If Access has inserted a function suggestion, replace it with the quoted value.
On the Query Tools Design tab, click Run and check that the results match the criterion.

Work with spreadsheet data in WPS Office
For spreadsheet-based work, WPS Office is a free, lightweight alternative with a familiar interface and support for Microsoft Office formats, making it easy to move existing files. It does not disable Access IntelliSense or replace Access databases and queries.

Frequently Asked Questions
Can I turn off Query Designer IntelliSense in Access 2013?
Access 2013 does not provide a setting to disable this behavior. Enter text criteria in double quotation marks as a workaround.
How do I search for the exact text A in a query?
Open the query in Design View and enter "A" in the Criteria row under the relevant text field, then click Run.
What should I do if Access changes A to ABS?
In the query design grid, replace the inserted function name with the quoted text criterion "A", then run the query.
Will quotation marks disable autocomplete for other queries?
No. Quotation marks identify an individual criterion as text; they do not change the autocomplete behavior in other queries.




