Set the number of decimal places to display in a field or control

The DecimalPlaces property provides a default setting, Auto, and the option to specify from 0 to 15 decimal places. When set to Auto, fields with Format property settings of Currency, Fixed, Standard, Percent and Scientific display two decimal places. The DecimalPlaces property has no effect unless the field or control has a Format property setting.

Set the number of decimal places to display for a field in table Design view

1. Open a table in Design view.
2. In the upper portion of the window, click the field you want to define decimal places for.
3. In the lower portion of the window, click the arrow next to the DecimalPlaces property box, and then click the desired number of decimal places.

Set the number of decimal places to display for a field in query Design view

1. Open a query in Design view.
2. In the query design grid, place the insertion point in the column for the field you want to change. You can place the insertion point in any row for that field.
3. Click Properties on the Query Design toolbar to open the property sheet for that field.
4. On the General tab, click the arrow next to the DecimalPlaces property box, and then click the desired number of decimal places.

Set the number of decimal places to display for a control in form Design view or report Design view

1. Open a form or report in Design view.
2. Make sure the control you want to change is selected, and then click Properties on the Form Design or Report Design toolbar to open the property sheet for the control.
3. Click the DecimalPlaces property box, click the arrow, and then select the desired number of decimal places.

Note   This procedure does not apply to data access pages.