Ability to format SQL so it's easier to read

[thardyjackson]

Is there an add-in or some way to format my SQL like adding line breaks, etc. It's hard to review and debug when I have one long sequence. I'll add carriage returns but they aren't saved when I reload the sql.

Thanks

MS Access 2010

 

[Galaxiom]

We all wish for this, and the supression of those confounded parentheses that Access insists in including.

If I am designing a complex query structure I will sometimes edit it in Notepad and paste it over to the SQL view.