Is there Beautify feature in Access SQL Editor?

[tdaccess]

Is there a beautify feature in the Microsoft Access Editor? For example, I may type in my SQL syntax code like this:

SELECT
columnA,
columnB,
columnC,
columnD,
(SELECT subcolumnA FROM tableZ) as columnE
FROM
table_A
WHERE
columnA = 1;

But when I save it and reopen it, the syntax gets all mushed together. So aggravating.

SELECT columnA, columnB, columnC, columnD, (SELECT subcolumnA FROM tableZ) as columnE FROM table_A WHERE columnA = 1;

This make it so hard to read and following when I'm trying to debug the syntax.

Thanks,

[ajetrumpet]

what I usually do is use NOTEPAD and tab back and forth between windows so I can read what I'm writing. copying and pasting doesn't take but milliseconds.

and yes, it's annoying as HECK. but I've found that pushing the SAVE button when you're in sql view actually saves the spacing and linebreaks sometimes! never found consistency with it though. =(

[tdaccess]

I remember this being a problem with earlier versions and I thought Microsoft would have added this as a new feature by now. Seems so obvious that it would be a very beneficial feature for everyone.

[ajetrumpet]

I don't know. I'm sure enough complaints will yield it at some point, but you have to take into consideration that adding this feature doesn't make them any more money, so they'll wait to add it I'm sure.

and hey, I'm going to mark this thread as solved. unmark it if you need to ask more questions.