formatting the query

[Guest]

Hi All

When I write the query and use the carriage return to format it so it is
more readable then initially thats fine but once i close the query and reopen
it the formatting has gone to pot !

Is there a way to stop access altering my formatting?

Thanks

Reggiee

 

[Guest]

Not that I know of. I certainly hope that someone knows better than me as I'd
like my SQL to stay the same way I wrote it.

 

[OfficeDev18 via AccessMonster.com]

If there is I haven't found it in 6 years of Access programming. All I know
of is to use the <Shift><F2> sequence to zoom in and out of any line too long
to read on the screen.

Incidentally, <Shift><F2> does not work when you're running a program in
debug mode (at least not in A2K3). It'll give an error message.

Sam