Work with Number Formatting

How to Work with Number Formatting in Access

Access Training

Access Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Work with Number Formatting

You can quickly change the formatting of values in forms and reports to display dollar signs, percent signs, or to change the number of decimal places.

  1. In Layout View, click the field you want to format.
  2. Click the Format tab.
    • Apply Currency Format: Formats the value with a dollar sign and marks the thousands place with a comma.
    • Apply Percent Format: Displays the value as a percentage with a percent symbol.
    • Apply Comma Number Format: Is similar to Currency format, but without the dollar sign.
    • Increase Decimals: Increases the number of decimal places that are displayed.
    • Decrease Decimals: Decreases the number of decimal places that are displayed.
      Work With Formatting

You can also apply number formatting by clicking the Format list arrow in the Number group and selecting a number format.