Add or remove a thousands separator in a number
- In design mode, right-click the text box or expression box whose data you want to format, and then click Control Properties.
- On the Data
tab or the General tab in the Control Properties dialog box, click Format.
Note You can add a thousands separator only for text boxes that have a decimal or whole number data type, or for expression boxes that are formatted as a decimal or whole number.
- In the Format dialog box, do one of the following:
- To add a thousands separator to the number, select the Use a digit grouping symbol check box under Other options.
- To remove a thousands separator from the number, clear the Use a digit grouping symbol check box under Other options.
Notes
- Depending on locale, the separator may separate more or less than thousands.
- Adding or removing a thousands separator affects only the displayed value, not the value that is saved in the data source.