Microsoft Access VBA Coding Conventions
Jump to navigation
Jump to search
General
Indentation
The indentation size is 4.
Empty lines
Variables
- Early binding
- No globals
- No abbreviations
- Make use of the variable type prefix
Access Classes
Forms
- Group
- Form event procedures
- From control event procedures
- Methods
Reports
Function
Name
The function name starts with a verb in lower case.
Result
The result variable is declared as first variable and the result assignment is the last statement in every function.
Conditions
- If, ElseIf, Else, End If
Loops
- Do Loop
- Not: While Wend