Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 920359 - Last Review: December 8, 2006 - Revision: 1.4
A decimal value in a column is rounded up or down to an integer value in Access 2007
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.
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.
To work around this problem, manually set the
Field Size property of the column to
Double or to
Decimal.
- 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. - 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. - Save the table.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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.
APPLIES TO
- Microsoft Office Access 2007
| kbexpertisebeginner kbtshoot kbprb KB920359 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate