ACC: General Number Format Ignores Decimal Number Setting

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

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

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:

   ARTICLE-ID: Q121098
   TITLE     : ACC: Fixed Format Required with Decimal Point Setting

   ARTICLE-ID: Q97524
   TITLE     : 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.