Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Saving editing format in Access SQL Window

Author  Topic 

BarryKeithNoble
Starting Member

9 Posts

Posted - 2007-08-08 : 14:58:30
Hello

I have recently been working with Access 2003 and using the SQL window to manipulate data. However despite coding in a sensible and readable way ( with indents and separate lines when appropriate), when I save the query, close and reopen the SQL window the code reassembles itself in a bunched up way.

Also is there a way for the Access SQL window to dispay MS SQL Server type colours for key words etc.

ashley.sql
Constraint Violating Yak Guru

299 Posts

Posted - 2007-08-09 : 16:56:49
there is not way to do this.
I have faced a lot of this when I used to work with access.

This is how access way built to work. Its so hard to work with black code and all bunched up. I understand your frustration.

Ashley Rhodes
Go to Top of Page
   

- Advertisement -