Try_Parse Function (Access custom web app)

Office 2013 and later

Parses a text value to the specified data type in the culture of the application or returns Null if the conversion is not valid.

Last modified: March 09, 2015

Applies to: Access 2013 | Access 2016

Note
The cloud storage feature described in this article is no longer supported in Office 2013 and Office 2016 and may result in the following error: Sorry, we’re having server problems, so we can’t add <service> right now. Please try again later. For cloud storage for Office Online, Office for iOS, and Office for Android, you can look into our Office Cloud Storage Partner Program.

Note

The cloud storage feature described in this article is no longer supported in Office 2013 and Office 2016 and may result in the following error:

Sorry, we’re having server problems, so we can’t add <service> right now. Please try again later.

For cloud storage for Office Online, Office for iOS, and Office for Android, you can look into our Office Cloud Storage Partner Program.

Syntax

Try_Parse(TextExpression, DataType)

The Try_Parse function contains the following arguments.

Argument name	Description
TextExpression	A text expression representing the formatted value to parse into the specified data type.
DataType	The data type into which to parse TextExpression.

Use Try_Parse only for converting from string to date/time and number types. For general type conversions, continue to use Convert.