SetValue action and "Visible" argument

[Andrew Wignall]

Dear all

I have followed the ACCESS help dialog to set up a form to enter report
criteria.... however after selecting the criteria and clicking the OK button
the macro hangs up with an error message ....
" .. invalid reference to property Visible ...... may not
exist or may not apply to object"


Macro is
Name OK
Condition True
Action Name SetValue
Argument [Visible], No

This is exactly as suggested by ACCESS help, and I can't find any further
help in the useless ACCESS 2003 online help
This used to work perfectly in ACCESS 97

Any ideas?

 

[Van T. Dinh]

I think you need to use the full reference to the Property like:

Macro Action: SetValue
"Item" argument: Forms![YourFormName].Visible
"Expression" arg: True

 

[Andrew Wignall]

Unfortunately didn't work. Made a statement like ' not an OLE object'
Any other ideas?
Thanks
Wig
(amateur)

I think you need to use the full reference to the Property like:

Macro Action: SetValue
"Item" argument: Forms![YourFormName].Visible
"Expression" arg: True

--
HTH
Van T. Dinh
MVP (Access)

Dear all

I have followed the ACCESS help dialog to set up a form to enter report
criteria.... however after selecting the criteria and clicking the OK button
the macro hangs up with an error message ....
" .. invalid reference to property Visible ...... may not
exist or may not apply to object"


Macro is
Name OK
Condition True
Action Name SetValue
Argument [Visible], No

This is exactly as suggested by ACCESS help, and I can't find any further
help in the useless ACCESS 2003 online help
This used to work perfectly in ACCESS 97

Any ideas?

 

[Van T. Dinh]

I tested in A2K and the statement I posted worked fine ...