ACC2000: Text Box Formatted as Currency Has a Space on the Right (208428)


The information in this article applies to:

  • Microsoft Access 2000
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.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbprb kbusage KB208428
©2004 Microsoft Corporation. All rights reserved.