Microsoft KB Archive/286333

= ACC2002: General Number Format Ignores Decimal Number Setting =

Article ID: 286333

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q286333



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

For a Microsoft Access 2000 version of this article, see 209626.



SYMPTOMS
When you select a number in the DecimalPlaces property setting, it appears to have no effect when the Format property is set to General.



MORE INFORMATION
When you add a text box control that is bound to a Numeric field to a form or report, if you do not set the control's Format property or if you set it 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. Also, having no format specified defaults to the behavior of the General Number format.

