totn Access 2007 VBA Debugging

MS Access 2007: Check Values in VBA

This MSAccess tutorial explains how to check values in the VBA debugging environment in Access 2007 (with screenshots and step-by-step instructions).

Checking values

In Access 2007, if you want to view the value of a variable or object (ie: text box, combo box, etc) in your VBA code at the time that the program was suspended, you can move your mouse pointer over that VBA code. Bubble text will appear displaying the variable/object name and its value in its current state.

Microsoft Access

In this example, we've moved the mouse pointer over the combo box called cboKeyword. The bubble text displays the cboKeyword combo box name with a value of "monitor".

This feature is useful if you need to quickly check a variable/object in your code.