Immediate Window in VBA Environment in MS Access

Immediate Window in VBA Environment

This MSAccess tutorial explains the Immediate Window in the VBA environment in Access (with screenshots and step-by-step instructions).

Immediate Window

The Microsoft Visual Basic window displays your VBA environment:

image 128
Immediate Window in VBA Environment in MS Access 3

Next, let’s analyze the Immediate window in the VBA environment.

image 129
Immediate Window in VBA Environment in MS Access 4

In Access, the Immediate window is usually found below the Code window. It is an essential element of the debugger found within the VBA environment. It lets you:

  • Type code and press ENTER to view the results of the code.
  • When in debug mode, it lets you view the value of a variable in its current state. This will be discussed in the tutorial on Debugging VBA Code.

If the Immediate window is not visible when you open the Microsoft Visual Basic window, you can make it visible by selecting Immediate Window under the View menu.