RJ multi-line label in a report

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?
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top