preserving the sql format

  • Thread starter Thread starter mario
  • Start date Start date
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
 
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.
 
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.
 
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.
 
Back
Top