Customizing the editor
The Interactive SQL view provides the same editing capabilities
as the file editor. It also has Script, Font, and Coloring properties
that you can change to make SQL files easier to read. With no change
in properties, SQL files have black text on a white background and a
tab stop setting of 3 for indentation.
Setting Script and Font
properties
Select Design>Options from the menu bar to open the Database
Preferences dialog box. The Script and Font properties are the same as
those you can set for the file editor.
For more information, see Using the file
editor.
Editor properties apply elsewhere
When you set Script and Font properties for the Database
painter, the settings also apply to the Script view, the file
editor, and the Debug window.
Setting Coloring
properties
You can set the text color and background color for SQL styles
(such as datatypes and keywords) so that the style will stand out and
the SQL code will be more readable. You set Coloring properties on the
Coloring tab page.
Enabling syntax coloring
Be sure the Enable Syntax Coloring check box is selected
before you set colors for SQL styles. You can turn off all Coloring
properties by clearing the check box.