This guide provides comprehensive examples for many of the topics discussed. The following typographic conventions are used:
Example of convention | Description |
Sub, If, ChDir, Print, Time$, RecordsAffected, Recordset |
Words in bold with initial letter capitalized indicate language-specific keywords with special meaning to VBA. Objects, methods, statements, functions, and properties appear in bold with the initial letter capitalized. Concatenated names may contain other capital letters. |
expr, path | In text, italic letters are used for defined terms, usually the first time they occur in the guide. Italics are also used occasionally for emphasis. In syntax, italics indicate placeholders for information you supply. |
[expressionlist] | In syntax, items in square brackets are optional. |
{While|Until} | In syntax, braces and a vertical bar indicate a choice between two or more items. You must choose one of the items unless all of the items are enclosed in square brackets. |
Dim rstCust As Recordset |
A monospace font indicates code. |
Set rstCust = dbCurrent._ OpenRecordset("Customers"_ dbOpenDynaset) |
If you are using Access Basic, Visual Basic 3.0, or VBA 3.0, the line-continuation character ( _ ) indicates that code continued from one line to the next in the guide should be typed as one line in the editor by omitting the line-continuation character and the preceding space. If you are using Visual Basic 4.0 or VBA 4.0 and later, you can continue a line of code in the editor by using the line-continuation character. |
ALT+F1, ENTER | Small capital letters are used for the names of keys and key sequences, such as ENTER and CTRL+R. A plus sign (+) between key names indicates a combination of keys. |