Microsoft KB Archive/208428

= ACC2000: Text Box Formatted as Currency Has a Space on the Right =

Article ID: 208428

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208428





SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.

A text box whose Format property is set to Currency on a form or on a report displays data with an extra space at the right end of the value.



CAUSE
The 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 Format property of the text box to a custom format or to a fixed format with two decimal places.

For example, if you change the Format property of the text box to $#,##0.00, values in the text box will be displayed without the space on the right end. Negative values will be displayed as -$nnn.nn, not as ($nnn.nn).



MORE INFORMATION
If 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 the footer section of a report 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

 * 1) Open the sample database Northwind.mdb.
 * 2) Open the Invoice report in Design view.
 * 3) Preview the report. Note that the Subtotal, Freight, and Total columns are correctly aligned.
 * 4) View the report in Design view.
 * 5) Click the Freight text box and change its Format property to $#,##0.00.
 * 6) Preview the report again. Note that Freight column is not aligned correctly.
 * 7) Close the report without saving the changes.

Additional query words: prb

Keywords: kbprb kbusage KB208428

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.