MS Access Format() Function

Format a numeric expression to percent:

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

value, format )

Required. The numeric value 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