Others

Disable Autocomplete for Criteria in Access 2013 Query Designer

Huda QurayshiHuda Qurayshi Nov 22, 2026 868 views

Question details

The user wants to stop Access 2013 Query Designer from changing a text criterion into a function suggestion.

Disable Autocomplete for Criteria in Access 2013 Query Designer
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.
Before you start

Open the database in Access 2013 and identify the query and text field where you want to enter the criterion.

Solution 1Recommended

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.

1
Open the query in Design View

In the Navigation Pane, right-click the query and select Design View.

2
Enter the quoted value

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.

3
Run the query

On the Query Tools Design tab, click Run and check that the results match the criterion.

Enter text criteria in quotation marks
Autocomplete remains enabled: Quotation marks help Access interpret the criterion as text; they do not turn off IntelliSense.
Free Microsoft Office alternative

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.

Filter spreadsheet data when an Access query is not neededOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar interface for everyday office tasksWork with a free, lightweight office suite
microsoft office alternative - wps office

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.