Try_Convert Function (Access custom web app)

Office 2013 and later

Converts a value to a specified data type or returns Null if the conversion is not valid.

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.

Try_Convert (DataType, Expression)

The Try_Convert function contains the following arguments.

Argument name

Description

DataType

The data type into which to convert Expression.

Expression

The value to be converted.

Try_Convert takes the value passed to it and tries to convert it to the specified DataType. If the conversion succeeds, Try_Convert returns the value as the specified DataType; if an error occurs, null is returned. However if you request a conversion that is explicitly not permitted, then Try_Convert fails with an error.

Show: