The information in this article applies to:
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
CAUSEThe space at the right end of the value is required for a closing parenthesis for negative values. The space keeps the decimal point aligned for positive and negative values. RESOLUTION
Change the text box's Format property to a custom format or to a fixed
format with two decimal places.
STATUSThis behavior is by design. MORE INFORMATIONIf you format some text boxes on a form with a currency format and others with a custom format, you may have trouble aligning columns of figures. For example, if you format totals in a report's footer section with a currency format, but use a custom format, or no format, on the text boxes above the footer, the columns may not be automatically aligned. Steps to Reproduce Behavior
REFERENCESFor more information about formatting a field, search the Help Index for "Format," and then "Format Property" or ask the Microsoft Access 97 Office Assistant.
Keywords : kbusage RptLayou |
Last Reviewed: March 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |