ACC2000: General Number Format Ignores Decimal Number Setting

ID: Q209626


The information in this article applies to:

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


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.


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:

Q208919 ACC2000: Fixed Format Required with Decimal Point Setting
Q210564 ACC2000: Round or Truncate Values to Desired Number of Decimals


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.

Additional query words: formatting prb


Keywords          : kbdta FmsHowto 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: May 13, 1999