alignment of multiple format types 1

[wtmckown]

My report detail has several rows of text boxes that contain a mixture of currency, integer and single values. These types are mixed under common header labels in the page header section. I can't get the data to align properly with the mixed formatting. The text boxes are the same width and use the same font in the same size and weight. I have tried text align settings of general and right with no impact on this problem.

Example: (Desired Result)

JANUARY DATA
DOLLARS $100,000.00
WEIGHT 58,000.00


Example: (Actual Result)

JANUARY DATA
DOLLARS $100,000.00
WEIGHT 58,000.00

The DOLLARS text box is formatted as Currency 2 Decimals and the WEIGHT text box is formatted as Standard 2 Decimals. If it came out aligned like the example above I would not be here today. The WEIGHT number appears out of alignment to the right. I could make them both the STANDARD format and lose the dollar sign but it's more readable with the proper formatting. Any thoughts, ideas or suggestions will be greatly appreciated.

 

[JoJ]

I do not remember at which Access version the right margin property of the text box was added.

See if you have the margin property. It might help.

 

[dhookom]

You may need to move your text boxes just slightly to account for this. I think part of the issue is that Currency fields may show negative values using () while normal decimal fields display negatives with - ie:
($100.00)
or
-100.00
The currency field display saves room on the right for the &quot".

Duane
MS Access MVP