Microsoft KB Archive/920359

= A decimal value in a column is rounded up or down to an integer value in Access 2007 =

Article ID: 920359

Article Last Modified on 12/8/2006

-

APPLIES TO


 * Microsoft Office Access 2007

-



SYMPTOMS
When you enter a decimal value in a column in Microsoft Office Access 2007, the decimal value is rounded up or down to an integer value.

This problem occurs when all the following conditions are true.
 * The table is created in DataSheet view.
 * The first value that you enter in the first row of the column is an integer value.



CAUSE
When the first value that you enter in the first row of the column is an integer value, Access 2007 automatically sets the data type of the column to Number. Additionally, the Field Size property of the column is set to Long Integer. Therefore, the decimal value that you enter in the column is rounded up or down to the integer value.



WORKAROUND
To work around this problem, manually set the Field Size property of the column to Double or to Decimal.
 * 1) Click the DataSheet tab. In the Views group, click the arrow under View, and then click Design View.

Note If the table has not already been saved, you will be prompted to save the table with a table name that you provide.
 * 1) Locate the column that you want to change, and then set the Field Size property of the column to Double or to Decimal.

Note If you set the Field Size property of the column to Decimal, you must also set the Scale property of the column. When you set the Scale property, you specify the maximum number of digits that can be stored to the right of the decimal separator.
 * 1) Save the table.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
If the first value that you enter in the first row of the column is a decimal value, Access 2007 automatically sets the Field Size property of this column to Double. Therefore, you do not encounter the problem that this article describes.

Additional query words: AC2007 ACC2007 Access2007

Keywords: kbexpertisebeginner kbtshoot kbprb KB920359

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.