SetValue action and "Visible" argument

  • Thread starter Thread starter Andrew Wignall
  • Start date Start date
A

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?
 
I think you need to use the full reference to the Property like:

Macro Action: SetValue
"Item" argument: Forms![YourFormName].Visible
"Expression" arg: True
 
Unfortunately didn't work. Made a statement like ' not an OLE object'
Any other ideas?
Thanks
Wig
(amateur)


Van T. Dinh said:
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)



Andrew Wignall said:
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?
Click to expand...
Click to expand...
 
Back
Top