THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Format() Function

❮ MS Access Functions

Example

Format the "Price" column to currency:

SELECT Format(Price, "Currency") AS FormattedPrice
FROM Products;
Try it Yourself »

Definition and Usage

The Format() function formats a string expression.

Syntax

Format(expression, format)

Parameter Values

Parameter Description
expression Required. The string expression to format
format Optional. The format to apply to the expression.
Format Description
General Number Displays a number without thousand separators
Currency Displays thousand separators as well as two decimal places
Fixed Displays at least one digit to the left of the decimal place and two digits to the right of the decimal place
Standard Displays the thousand separators, at least one digit to the left of the decimal place, and two digits to the right of the decimal place
Percent Displays a percent value - with a percent sign. Displays two digits to the right of the decimal place
Scientific Scientific notation
Yes/No Displays No if the number is 0 and Yes if the number is not 0
True/False Displays False if the number is 0 and True if the number is not 0
On/Off Displays Off if the number is 0 and On if the number is not 0
General Date Displays date based on your system settings
Long Date Displays date based on your system's long date settings
Medium Date Displays date based on your system's medium date settings
Short Date Displays date based on your system's short date settings
Long Time Displays time based on your system's long time settings
Medium Time Displays time based on your system's medium time settings
Short Time Displays time based on your system's short time settings

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

❮ MS Access Functions