Access Auto Formatting (of Query SQL)

[Big X]

Hello,

In access when I write my sql statement to produce work when I reload a saved file it seems that access changes everything. i.e I will write code

line 1
line 2
line 3

When I reload access sometimes it adds code that may be necessary but it also put everything basically into one line after the Where statement usually. I was just wondering if there is a way to turn this off so it will leave the sql in the original format.

[NeoPa]

Your title almost threw me off this one ;)

In answer to your question though, I believe not :(

I did think it would keep the originally entered SQL as long as you don't try to make changes in Design View. However, although that keeps it when switching between views, it is reformatted when saved I'm afraid.