preserving the sql format

M

mario

Lets say following is my SQL:
Line1.....Line2......Line3

What can I do to preserve the visual appearance or format
of my sql like

this:
Line1......
Line2......
Line3......

When ever I change the sql code in "sql-view", save and
come back again it

all consolidates into one single line. I want my sql code
to break up and

appear in separate lines.

Pls help
 
R

Rick Brandt

mario said:
Lets say following is my SQL:
Line1.....Line2......Line3

What can I do to preserve the visual appearance or format
of my sql like

this:
Line1......
Line2......
Line3......
Click to expand...

Nothing. You cannot prevent Access from rearranging the SQL.
 
J

John Vinson

What can I do to preserve the visual appearance or format
of my sql
Click to expand...

Nothing, other than keeping a copy external to Access.

This (and the ability to add comments and to search & replace in SQL)
have been requested as enhancements. Don't hold your breath though.
 
M

mario

Hey john,

Thanks for all your help. This message board is just
awesome.

Long Live MicroSoft and its user friendly products and
excellent support tools. I'm Lovin it!!

Hey, on the lighter side, may I ask what made you say in
your last line "Don't hold your breath though". Just
wondering because thatz what my personal trainer at my
gym says all the time :)

Anywayz, Thank you. Thank you and Thank you.
 
Top