Microsoft KB Archive/96574

= ACC: General Number Format Ignores Decimal Number Setting =

Article ID: 96574

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q96574



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
The Decimal Number you place in the DecimalPlaces property setting appears to have no effect when the Format property is set to General.



STATUS
This is by design.



MORE INFORMATION
When you add a text box control to a form or report bound to a Numeric field, if the control's Format property is set to General Number, the DecimalPlaces property setting will have no effect. This is because the General Number format displays only the number of decimal places necessary for each value.

For more information about decimal places, please see the following article in the Microsoft Knowledge Base:

121098 ACC: Fixed Format Required with Decimal Point Setting

97524 ACC: Round or Truncate Values to Desired Number of Decimals

