Microsoft Access VBE
Jump to navigation
Jump to search
Shortcuts
The shortcuts for window navigation and handling are taken as granted and will not be listed here.
The term "procedure" encompasses Sub, Function and Class Module Properties.
| Shortcut | Action |
|---|---|
| Ctrl+G | Direct Window |
| Ctrl+R | Project Explorer |
| Ctrl+W | Trace values |
| F2 | Object Catalogue |
| Shift+F2 | Jump to the declaration of the variable, function or enumeration the cursor is located on |
| Ctrl+F2 | Jump to the combo boxes containing the currently used objects and their properties and methods |
| F4 | Properties |
| F5 | Run / Continue |
| Shift+F5 | Stop |
| F7 | Code Window |
| F8 | Next step |
| Shift+F8 | Next step, stepping over the procedure |
| Ctrl+F8 | Execute until cursor position is reached |
| Ctrl+Shift+F8 | Execute until the end of the current procedure |
| F9 | Toggle break point |
| Shift+F9 | Display current value |
| Ctrl+F9 | Set execution point |
| Ctrl+Shift+F9 | Remove all break points |
Annoyances
Case Change
The VBE keeps track of the capitalization of variables. Unfortunately this sometimes leads to wrong "auto correction" especially in enumerations. The best way to teach the editor the correct capitalization of a function, an enumeration value or a variable is to
- Declare a variable in a module with the same name
Public MyCorrectCapitalization
- Save and compile (you will run into an error but can ignore it)
- Remove the public declaration