Format SQL Queries

  • Thread starter Thread starter Ralf
  • Start date Start date
R

Ralf

Hi,

I've quite long queries. Now after entering and formating those queries in a
readable format, as soon as I close and reopen the SQL View in MS Access, the
query is just one large string. Is there a way to keep the format?

Thank you,
Ralf
 
Hi,

I've quite long queries. Now after entering and formating those queries in a
readable format, as soon as I close and reopen the SQL View in MS Access, the
query is just one large string. Is there a way to keep the format?

Thank you,
Ralf
Click to expand...

Alas, no, not in Access (despite years of groaning and grumbling).

All I can suggest is copying and pasting into an external text file after you
have it working.
 
On Tue, 17 Mar 2009 18:29:00 -0700, Ralf

All I can say is that this is an often-requested feature, and that
some people are trying hard to listen.
But in the current version: no, you're out of luck.

-Tom.
Microsoft Access MVP
 
Back
Top