Design View - hover over value

[Guest]

For the life of me, I can't figure out why sometimes when I hover over a
variable, it will show a block that contains the value, but other times,
although I believe I have tried everything possible, I can't get it show
those values. Can anyone help? Thanks.

 

[Allen Browne]

In the VBA window, Access shows you the value only if:
a) The code is running. If it is not in break mode, there is nothing to
show.

b) You hover over something it can show a value for. For example, it can't
show a value for a keyword.

If you are trying to track the value of variables, another useful technique
is to print it to the Debug window (also called Immediate Window.) For
example, to show the value of MyVariable whenever a line of code executes,
you would put this on the next line in your code:
Debug.Print "MyVariable was " & MyVariable & " at " & Now()
After it executes, press Ctrl+G to see the output.

In the code window, the View menu also offers you a Local and a Watch window
that can also help.