Type mismatch in condition embedded macro

[geremore]

Hi,

Got simple form with textbox (EmpName) and button (ViewReport). The On Click embedded macro (of the button) starts with a condition: [EmpName].Text <> ""
Clicking the button (placed on the same form as the textbox) the condition results in a type mismatch.


Anybody any idea what might be wrong?

Thanks in advance,
Geremore

[pbaldy]

I don't use macros but in code you can't use the .Text property of a control unless the control has focus, which it won't when the button is clicked. Try using the .Value property instead.

[geremore]

OK, that works, thanks!

[pbaldy]

Happy to help!