IIF
The IIF function returns one of two objects, depending on the evaluation of an expression.
Syntax :
IIF(Value,TruePart,FalsePart)
| Parameters | Description |
|---|---|
| value | Expression that you want to evaluate. |
| TruePart | Value or expression returned if Expression is True. |
| FalsePart | Value or expression returned if Expression is False. |
Example :
Report.Fields("NAME").Visible = IIF((Param2="Value"), "False", "True")