Choose Function (Access custom web app)

Office 2013 and later

Returns the item at the specified index from a list of values.

Last modified: March 09, 2015

Applies to: Access 2013 | Access 2016

Important note Important

Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

Choose (IndexNumber, Value [,Value_n ])

The Choose function contains the following arguments.

Argument name

Description

IndexNumber

An integer expression that represents a 1-based index into the list of the items following it.

Value

List of values of any data type.

If the provided IndexNumber is not an integer, then the value is implicitly converted to an integer.

If the index value exceeds the bounds of the array of values, then Choose returns NULL.

Show: