MS Access Format() Function

Format the "Price" column to Currency:

The Format() function formats a value with the specified format.

value, format )

Required. The string to format format Optional. The format to to use.

Indicates a number, without thousand separators

Indicates currency, with thousand separators and two decimal places

Shows minimum one digit to the left of the decimal place and two digits to the right of the decimal place

Shows the thousand separators + minimum one digit to the left of the decimal place, and two digits to the right of the decimal place

Shows a percent value (with percent sign) and two digits to the right of the decimal place

= 0 and Yes if value <> 0

= 0 and True if value <> 0

= 0 and On if value <> 0

Shows value as a date based on the system settings

Shows value as a date based on the system's long date settings