ACC: General Number Format Ignores Decimal Number Setting (96574)


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
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

REFERENCES

For more information about how Microsoft Access handles decimals, search the Help Index for "DecimalPlaces Property," or ask the Microsoft Access 97 Office Assistant.
Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbprb KB96574
©2002 Microsoft Corporation. All rights reserved.