Share via

how to display variable value

Anonymous
2013-05-06T05:44:07+00:00

I am using the OpenArgs (function?) to display report criteria.  Can I display the value using the VB Watch window or the immediate window?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2013-05-07T03:59:40+00:00

    There are a number of debug tools for this purpose. I'll usually set a "Breakpoint" by mouseclicking in the grey vertical bar to the left of the code window, next to some executable statement (i.e. not a Dim statement or a comment). You can then perform whatever form action calls the code (e.g. a button click, updating a control, whatever the event might be); the code will run up to the mark and stop. You can then use function keys (F8 steps one line of code, F9 runs the rest of the code, etc.) or equivalently use the options on the Debug menu.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2013-05-07T02:25:34+00:00

    Stupid question How do I make the code run while viewing the code?

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2013-05-06T06:19:11+00:00

    ?Me.OpenArgs

    in the Immediate window works. I'd be interested to know if the Watch window can be used for this - as far as I know it's just for dimensioned VBA variables, but I'd be happy to learn otherwise!

    Was this answer helpful?

    0 comments No comments