Using the IIF Function
In this tutorial you will learn how to use the IIF Function.
The IIF function returns one of two parts depending on the outcome of an expression.
=IIF( Expression, TruePart, FalsePart )
Expression to evaluate
TruePart is the value to return if the expression is TRUE
FalsePart is the value to return if the expression is FALSE
In this example we will use Grades and if a particular score is achieved you will pass or fail.
If the Grade was "75" and the Expression checked for ">65" the result is TRUE.
In a Form you could set the Default Value of a Textbox to
=IIF(75>=65, True, False)
In a Form add a TEXTBOX control and rename it "txtIIF", then you could add the following in the Load Event.
Private Sub Form_Load()
txtIIF = IIF(75>=65, True, False)
Access Expert 25
See this FREE Tip on IIF and many others.
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips