Format 1000 as 1K or 1,000

Sometimes you want to format a number for reports, for easier reading, or just plain simplification.

  • Formatting the number with a comma
    1. Switch to Layout or Design view of your form or report
    2. Select the field Object with numerical data
    3. In the property sheet, under Format>Format
    4. 0,000 for thousands 0,000,000 for millions

  • Formatting the number as ###k
    1. Switch to Layout or Design view of your form or report
    2. Select the field Object with numerical data
    3. In the property sheet, under Format>Format
    4. 0,\k

      or, for millions

      0,,\m