Free E-Books

The continuation
characters are placed after the commas separating the elements contained in the complex
statement, making the statement easier to read and understand.
FIGURE 11-2
Use the continuation character to split long strings into multiple lines.
Another powerful feature of the Access code editor that is probably not evident in Figures 11-1 and
11-2 is the text colors used to set aside comments, keywords, and identifiers. Although it??™s not obvious
in this book??™s figures, the comments in Figures 11-1 and 11-2 appear in a green font while the
VBA keywords like Function, Const, and If are blue. Identifiers like conObjStateClosed
and conDesignView, as well as the procedure name (IsLoaded) in Figure 11-1, are black.
You can adjust the editor font and text colors to suit your particular style. The Editor Format tab of
the code Options dialog box (Tools ??? Options from the code editor) contains all of the options necessary
to select the font, font size, and colors for any number of different parts of the VBA syntax
(see Figure 11-3).


Pages:
831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855