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

Question

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

Quizplus · Accepted Answer

This statement is true. Access automatically adds double quotation marks around values in Short Text fields in the design grid when the query is run or the insertion point is moved to another cell. This is because Short Text fields can contain alphanumeric and special characters, and enclosing the value in quotation marks ensures that it is treated as text and not as a calculation or function.

Access Automatically Adds Double Quotation Marks Around Values in the Design