Stop auto formatting of queries

[hbrems]

Is there any way in Access 2007 and up to stop the auto formatting of queries?

For example:

line 1
line 2
line 3

becomes:

line1, (line2, (((line3))))

It seems to be fine as long as you avoid the design interface but sometimes there's no escaping.

 

[Galaxiom]

You, me a thousands of others wish there was as way but unfortunately no.

If I am doing a particularly complex query with multiple levels of subqueries I sometimes drop the text into Notepad where I can control the formatting. Nothing more annoying than your carefully indented strucure being wiped out by Access because you went into Design view.

And those fecking brackets. It is obsessed.

 

[hbrems]

It would be nice if they would put some work into the SQL editor. It's madness!!