The IIf function checks the expression passed in and returns the True part or the False part.
|
Syntax | ||||
|
IIf(Expression, TruePart, FalsePart) | ||||
|
Return value | ||||
|
Type |
Description | |||
|
Result |
Variant | |||
|
Parameter | ||||
|
Use |
Name |
Type |
Passing |
Description |
|
Required |
Expression |
Variant |
ByVal |
Expression of which to check |
|
Required |
TruePart |
Variant |
ByVal |
Value to get result if the validated expression is TRUE |
|
Required |
FalsePart |
Variant |
ByVal |
Value to get result if the validated expression is FALSE |
This feature is particularly useful when using in expressions to control the state of controls:
