Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: General Number Format Ignores Decimal Number Setting

ACC2000: General Number Format Ignores Decimal Number Setting

View products that this article applies to.

This article was previously published under Q209626
Moderate: Requires basic macro, coding, and interoperability skills.

For a Microsoft Access 2002 version of this article, see 286333 (http://support.microsoft.com/kb/286333/EN-US/).

↑ Back to the top

Symptoms

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

↑ Back to the top

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 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.

For additional information about decimal places, please see the following articles in the Microsoft Knowledge Base:
208919 ACC2000: Fixed Format Required with Decimal Point Setting
210564 ACC2000: Round or Truncate Currency Values to the Intended Number of Decimals

↑ Back to the top

References

For more information about how Access handles decimals, click Microsoft Access Help on the Help menu, type DecimalPlaces Property in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top

Keywords: KB209626, kbprb

↑ Back to the top

Article Info
Article ID : 209626
Revision : 2
Created on : 6/28/2004
Published on : 6/28/2004
Exists online : False
Views : 343