Avatar of morinia
morinia
Flag for United States of America

asked on 

SQL query formatting loss in Access VBA

Experts,

Not a big issue, but is there any way to keep the formatting in an SQL Query in Access?
I find it easier to read and modify when the query is not all together on one line.
example:
Select
        TableA.FieldA,
        TableA.FieldB,
        TableA.FieldC,
        TableB.FieldD
From TableA join TableB
on TableA.FieldA = TableB.FieldA;

When I close and reopen query  get  something like this.

Select TableA.Fielda,TableA.Fieldb, ableA.Fieldc,TableB.FieldD,From TableA  join TableB on TableA.FieldA = TableB.FieldA;
SQL

Avatar of undefined
Last Comment
ste5an

8/22/2022 - Mon