Microsoft KB Archive/208919

= ACC2000: Fixed Format Required with Decimal Point Setting =

Article ID: 208919

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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

Field Name: Test

Data Type: Number

FieldSize: Double

DecimalPlaces: 3

 View the table in Datasheet view. Type the following number in the Test field:

1.12345

Note that the number is displayed with five decimal places.</li></ol>

<div class="references_section">