Microsoft KB Archive/121098

= ACC: Fixed Format Required with Decimal Point Setting =

Article ID: 121098

Article Last Modified on 1/19/2007

-

APPLIES TO


 * 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.



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:

<pre class="fixed_text">     1.12345

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

<div class="references_section">