Format Function (Access custom web app)

Office 2013 and later

Returns a value formatted according to a specified pattern.

Last modified: March 09, 2015

Applies to: Access 2013 | Office 2013

Format (Expression, Format)

The Format function contains the following arguments.

Argument name



Expression of a supported data type to 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.

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

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)