IsNull in the Action Argument

D

D Mullins

Wanting to use the SetValue action to set the Tag of the Active Screen Form to Null. What is the proper syntax? "Null" IsNull, Null, etc. When I used IsNull (without quotes), the macro failed. Access bracketed the [IsNull] making it an object rather than an expression.
 
K

Ken Snell

I believe that the Tag property is text. Set it equal to "" (empty string).

--
Ken Snell
<MS ACCESS MVP>

D Mullins said:
Wanting to use the SetValue action to set the Tag of the Active Screen
Click to expand...
Form to Null. What is the proper syntax? "Null" IsNull, Null, etc. When
I used IsNull (without quotes), the macro failed. Access bracketed the
[IsNull] making it an object rather than an expression.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

object does not contain automation object form- error 5
Type Mismatch in Macro with empty string/null value 7
setting the argument in SETVALUE Action of macro 6
Error Message - Please Help 2
Access2000 converted to Access2007 0
The expression you used has a function name Access can't find 2
Where did the SetValue action go? 5
Help with a Query running off of VBA 4

Top