Knowledge Base

ACC: Fixed Format Required with Decimal Point Setting

Article ID: 121098

Article Last Modified on 1/19/2007

Microsoft Access 2.0 Standard Edition
Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

This article was previously published under Q121098

Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

In a table or query, if you set the number of decimal points in a Double Number field without setting the field's Format property to Fixed, the DecimalPlaces property setting will have no effect on the display of the data.

CAUSE

The DecimalPlaces property setting has no effect if the Format property is set to General Number. When the Format property is left blank, it automatically defaults to the General Number setting. Therefore, if you leave the Format property blank, the DecimalPlaces property setting will have no effect.

RESOLUTION

Change the field's Format property setting in the table or query to something other than blank or General Number.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Create a new table.

Add the following field to the table:

      Field Name: Test
         Data Type: Number
         FieldSize: Double
         DecimalPlaces: 3

View the table in Datasheet view.
Enter the following number in the Test field:
```
      1.12345
						
```
Note that the number is displayed with five decimal places.

REFERENCES

For more information about the DecimalPlaces property, search the Help Index for "DecimalPlaces property," or ask the Microsoft Access 97 Office Assistant.

Keywords: kbprb KB121098