Access automatically adds double quotation marks around values in the design grid that are formatted as Text fields when you run the query or move the insertion point to another cell in the design grid.

Question

Quizplus · Accepted Answer

This is true. Access automatically adds double quotation marks around values in Text fields in the design grid when you run the query or move the insertion point to another cell in the grid. This is because text values need to be enclosed in quotation marks to distinguish them from other types of values, such as dates or numbers.

Access Automatically Adds Double Quotation Marks Around Values in the Design