The Switch function is a built-in function in Microsoft Access. Evaluates a list of expressions and returns a Variant value or an expression associated with the first expression in the list that is True. You can include a path, if necessary. If the path contains spaces, enclose it in quotation. This information applies to all versions of Office from 2007 through to 365. In Microsoft Access, Switch is a very useful and powerful function that allows you to build conditional branching logic into your expressions in queries, forms, and reports.