Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 208428 - Last Review: June 24, 2004 - Revision: 2.0
ACC2000: Text Box Formatted as Currency Has a Space on the Right
This article was previously published under Q208428
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.
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.
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).
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
- Open the sample database Northwind.mdb.
- Open the Invoice report in Design view.
- Preview the report. Note that the Subtotal, Freight, and Total columns are correctly aligned.
- View the report in Design view.
- Click the Freight text box and change its Format property to $#,##0.00.
- Preview the report again. Note that Freight column is not aligned
correctly.
- Close the report without saving the changes.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate