How to Use Iif Function MS Access

Quick summary

The IIf function in MS Access lets you apply conditional logic directly inside a form's Control Source property, returning different values based on whether a condition is true or false. This tutorial walks you through adding a Text Box control in Design View and binding it to an IIf expression so your form displays dynamic, condition-driven results.

Steps

1. Open a form in Design View.
2. Add a Text Box control to the form.
3. In the Property Sheet, navigate to the Data section.
4. Click on the ellipsis icon next to the Control Source field.
5. Set the control's Control Source property to an IIf expression and click OK.
6. Save the changes by clicking the save icon.