Format Function (Access custom web app)

Returns a value formatted according to a specified pattern.

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, look into our Office Cloud Storage Partner Program.

Syntax

Format (Expression, Format)

The Format function contains the following arguments.

Argument name	Description
Expression	Expression of a supported data type to format.
Format	A format pattern. The format argument must contain a valid format string, either as a standard format string (for example, "C" or "D"), or as a pattern of custom characters for dates and numeric values (for example, "MMMM dd, yyyy (dddd)"). For more information, see Remarks.

Remarks

For the Format parameter, pass strings that match any of the following patterns:

• Standard Numeric Format Strings

• Custom Numeric Format Strings

• Standard Date and Time Format Strings

• Custom Date and Time Format Strings

You cannot use the Format function in the following areas of Access 2013 web apps:

• Calculated columns at the table level

• UI macros

• Expressions in views (for example, in forms)