Alignment of calculated field....How?

  • Thread starter Thread starter DazedConfused
  • Start date Start date
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
 
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
 
Back
Top