RJ multi-line label in a report

  • Thread starter Thread starter jfp
  • Start date Start date
J

jfp

In a report, i have labels as column headings. If the column is
currency, then i want to RightJustify the label. No problem -- unless
the width is insufficient such that 2 (or more) lines are needed for the
label. Example -- suppose label text is "Amount Paid". When this is
split into 2 lines for printing by Access, the lines are "Amount " and
"Paid". Then, using right justification, it appears like this:
Amount
Paid

The only way around this that i know is to make separate labels for each
line -- here, "Amount" and "Paid" would be 2 labels, one above the
other. This works, but is a nuisance.
Does anyone have a better trick for this ?

ALSO -- more specific to currency, Access seems to reserve space to the
right of the value for possible printing of a ')' as part of putting
negative amounts in parentheses. If i set the width and left values of
a column heading label and the corresponding text box for the currency
the same, and i right justify both, then: the label text ends at the
end of the reserved space, but the currency text ends to the left of it.
It sort of looks like this:
Amount
$1000

Then, i have to either set a right margin in the label or move it to
the left. Is there any property i can set for the text box to force it
to go all the way to the right?
 
For the labels, surely all you have to do is set the TextAlign property
to Right. Use Ctrl+Enter if you're typing text into a label and want to
force a linebreak rather than just let the text wrap.

For the currency fields, AFAIK you just apply a custom numeric format to
the textboxes instead of the default Currency format. Something like
"$#,##0;-$#,##0" should do it.
 
Back
Top