SQL Query Formatting

[alexcn]

Hi there,

I was wondering if anyone knew how to overide the automatic
reformatting that Access does to SQL queries when saving. In other
words I have my nice query all indented where required to make it
easier to decipher and then access goes and removes all the tabs!! Its
very frustrating!

Many thanks!

 

[Van T. Dinh]

Are you talking about MDB or ADP?

If MDB, once you have the SQL String the way you want, save it and never
open it in DesignView (Grid) or switch from SQL View/DatasheetView to
DesignView.

 

[alexcn]

Thanks for your reply. It was actually ADP whenever I create a query
in text it automatically screws up all the formatting so the identation
that made it all look "pretty" before is simply wiped!