screen.activeform issue when stepping into vba

Question

When I am trying to troubleshoot vba procedures and it hits a screen.activeform.control name, I get the error "You entered an expression that requires a form to be the active window."

How can I F8 past this, and still have it gather the required info from the screen.activeform.controlname statement?

Answer 1

Actually Don is correct. The VBA editor window does not mess up the Screen.ActiveForm. In the OP's case maybe no form has the focus.

Hi Tom. That's good to know. Thanks!

Answer 2

Ciao,

it seems you are in debug mode. Move the breakpoint after the statement.

Mimmo

Answer 3

Actually Don is correct. The VBA editor window does not mess up the Screen.ActiveForm. In the OP's case maybe no form has the focus.

Answer 4

Hi Karen. Screen.ActiveForm relies on a form having the focus. So, since you have forced the VBA IDE to have the focus, I guess Screen.ActiveForm wouldn't know which form should have the focus instead. Would you have any other way of determining the form you need other than using Screen.ActiveForm?

Answer 5

Hmmm, Is the form in form view or design view?

?screen.ActiveForm.ActiveControl works for me and returns the correct value in the Immediate Window, as long as the form is in Form View. (It's *so* nice to have dual monitors for this.)