How to Use Iif Function MS Access

‍

‍

Here’s how to do it:

‍

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.