Alignment of calculated field....How?

D

DazedConfused

Hi
I have the following fields in a form and I am adding them in a
calculated field. My problem is that the total that comes out
(Which is correct by the way) is misaligned. It seems the calculated
fields is placing the data to the furtherest left
of the field. How do I move it to the Right?


=[CURRENTCHRGES]+[LONGDISTCHRG]+[ADJUSTMENTS]+[INETCHARGES]

ie; CURRENTCHRGES = $33.00
LONGDISTCHRG = $1.77
ADJUSTMENTS = $0.00
INETCHARGES = $22.95

CALCULATED = $57.72

All the fields are set to currency, so how do I get
the calculated field to trim and align to the right correctly?
I have tried the RTrim() thingy and it doesn't work.
Any ideas?
Thanks
 
R

Rick B

While in design view, click the fileds and then click the "align right"
button on your menu.

Rick B


Hi
I have the following fields in a form and I am adding them in a
calculated field. My problem is that the total that comes out
(Which is correct by the way) is misaligned. It seems the calculated
fields is placing the data to the furtherest left
of the field. How do I move it to the Right?


=[CURRENTCHRGES]+[LONGDISTCHRG]+[ADJUSTMENTS]+[INETCHARGES]

ie; CURRENTCHRGES = $33.00
LONGDISTCHRG = $1.77
ADJUSTMENTS = $0.00
INETCHARGES = $22.95

CALCULATED = $57.72

All the fields are set to currency, so how do I get
the calculated field to trim and align to the right correctly?
I have tried the RTrim() thingy and it doesn't work.
Any ideas?
Thanks
 
Top