Quick summary
The Switch function in MS Access lets you return different values based on conditional expressions, similar to a multi-branch If-Then logic. This tutorial shows how to add a text box to a form and bind it to a Switch function expression using the Expression Builder.
Steps
- Open the form in Design View.
- Add a text box to the form.
- Set the Control Source by clicking the ellipsis icon in the property sheet.
- Enter your Switch function expression in the Expression Builder and click OK.
- Click the save icon to save your changes.
