Retain formatting in SQL view...

[MSherfey]

Some of my queries get a bit long and I need to do a lot of cut/paste in the SQL view. To help with this I like to format the code to make it easier to read. However, when I come back the next day the formatting is lost and everything is all bunched-up.

Does anyone know how to save the formatting in the SQL view?

 

[Guus2005]

You can't.

You can use more subqueries and join them in the main query.

HTH

 

[Uncle Gizmo]

Andrew Wrigley has a very nice solution:
http://blogs.msdn.com/clintcovington/archive/2007/01/26/sql-editing-and-versioning-tool-for-access.aspx

 

[MSherfey]

Thank you! It looks like Access 2007 on Vista is still in test, but I will happily keep them in mind.

Thanks again!