ACC2000: Fixed Format Required with Decimal Point Setting (208919)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q208919
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

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 has 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 has no effect.

RESOLUTION

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

MORE INFORMATION

Steps to Reproduce Behavior

  1. Start Microsoft Access and open any database.
  2. In the Database window, click Tables under Objects, and then click New.
  3. Add the following field to the table:

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

  4. View the table in Datasheet view.
  5. Type 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, click Microsoft Access Help on the Help menu, type decimalplaces property in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbprb KB208919
©2004 Microsoft Corporation. All rights reserved.