# How to Use Iif Function MS Access

> To use the Iif function in MS Access, open a form in Design View, add a Text Box control, and go to the Data section in the Property Sheet. Click the ellipsis icon, set the Control Source property to an IIf expression, click OK, and save the changes.

Canonical: https://livedemo.ai/tutorials/how-to-use-iif-function-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a51aaab56e05a00ffe896/preview?step=1

## Steps

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