Note The information in this topic applies only to a Microsoft Access database (.mdb).
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
Set the number of decimal places to display for a field in query Design view
Set the number of decimal places to display for a control in form Design view or report Design view
- Open a form or report in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
- Make sure the control (control: A graphical user interface object, such as a text box, check box, scroll bar, or command button, that lets users control the program. You use controls to display data or choices, perform an action, or make the user interface easier to read.) 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.
- 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.