You can use the DecimalPlaces property to specify the number of decimal places to display in a Number or Currency field or a control with number or currency data. You can set the DecimalPlaces property in table Design view, query Design view, form Design view, or report Design view. In most cases, you'll want to set the property for the field in table Design view. This way, the setting is automatically applied to the field in query Design view and to controls on a form or report bound to that field (as long as you create the controls after setting the property in table Design view). In certain cases, however, you may want to set the property in query Design view, form Design view, or report Design view. For example, you may want to display a different number of decimal places in a table datasheet than in a report. You could set the DecimalPlaces property for the field in query Design view and then base your report on the query. If you're using an unbound control, you'll need to set the DecimalPlaces property in form Design view or report Design view.
Return to Define the number of decimal places to display in a field or control