How to I say Is Not Null in VBA

问题:

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")

回答1:

Use Not IsNull(Fields!W_O_Count.Value)

回答2:

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)