SyntaxFix
Write A Post
Hire A Developer
Questions
Tags
Hi I have the following expression. I'm trying to say "if the second field Is Not Null". Can you help.
Thanks
=Iif((Fields!approved.Value = "N" & Fields!W_O_Count.Value IsNotNull), "Red", "Transparent")
This question is related to ms-access null vba
ms-access
null
vba
you can do like follows. Remember, IsNull is a function which returns TRUE if the parameter passed to it is null, and false otherwise.
Not IsNull(Fields!W_O_Count.Value)
Source: Stackoverflow.com