Alison Balter's Mastering Access 2002 Enterprise Development

The VBA String Editor

The VBA String Editor enables you to quickly and accurately build strings of text and variables for expressions of various kinds, including SQL statements and scripts. After you create them, you can easily embed these strings in your VBA code. To use the VBA String Editor, you must first activate it as an add-in using the technique described for the Code Librarian. After you have loaded the VBA String Editor, you are ready to use it. To use it, select String Editor from the Add-Ins menu. The VBA String Editor dialog box appears (see Figure 18.34).

Figure 18.34. The VBA String Editor helps you construct strings of text and variables for use in code.

The String Editor automatically puts quotation marks, spaces, carriage return ...