Is there any way to stop Microsoft Access from auto-formatting the SQL text? Specifically, I like to arrange my SQL text with blank lines and spaces to make it easier to read, but after saving it and re-opening it, the extra lines and spaces have been removed.
For example... the following SQL:
SELECT field1
, field2
, field3
FROM table1
WHERE field1 = 1
becomes...
SELECT field1, field2, field3
FROM table1
WHERE field1=1
Obviously, the above query is simple enough that this change doesn't matter, but when I have much more complicated queries and subqueries, the text arrangement is more important. Can this auto-arrangement of text in Access be turned off?
For example... the following SQL:
SELECT field1
, field2
, field3
FROM table1
WHERE field1 = 1
becomes...
SELECT field1, field2, field3
FROM table1
WHERE field1=1
Obviously, the above query is simple enough that this change doesn't matter, but when I have much more complicated queries and subqueries, the text arrangement is more important. Can this auto-arrangement of text in Access be turned off?
