Microsoft Office 2000 Developer

VBA String Editor

See Also

The VBA String Editor add-in assists in the formatting of strings for inclusion in Visual Basic for Applications (VBA) code. Complex strings such as SQL statements can be entered as standard text, and the String Editor will format the string with the proper quotation marks and other symbols and insert it into your code.

Using the VBA String Editor reduces the time developers spend building strings and hunting syntax errors by making it easier to create strings to embed long scripts or complicated SQL statements into VBA code.

For More Information   For more information about using the VBA String Editor add-in, see Working with String Variables.

Options

String Design Surface

Enter a string to be formatted in this area.

   String Edit Mode Toggle Toolbar Button

Toggles between formatted and unformatted text mode for the selected text. When in formatted text mode, variables appear in blue.

   Concatenation Symbol Toolbar Button

Toggles between the "&" and the "+" concatenation symbols for the selected text.

Note   Although either symbol will work as a concatenation operator, the "+" symbol is also used as an addition operator. If a string contains numerical characters, the "+" symbol will causes those numbers to be added together rather than displayed as a string. For best results, always use the "&" symbol when you want to concatenate strings.

Keyboard Shortcuts

The following keyboard shortcuts are available in the String Editor: