ACC: Fixed Format Required with Decimal Point Setting (121098)

The information in this article applies to:

Microsoft Access 2.0
Microsoft Access for Windows 95 7.0
Microsoft Access 97

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.

Modification Type:	Major	Last Reviewed:	5/6/2003
Keywords:	kbprb KB121098