Hi Steve,
In tax calculations I use the round() funtion but in all currency fields I use
$99,999,999.99 in the inputmask, not format. The result I get is the $ is always left justified as follows.
$ 2.39
$50,000.25
>I am having trouble with a field on my report. It is a field which which performs a sum function. The format is set to currency. The result adds zeros to the sum to fill in the textbox. I have tried Round(,2) but it doesn't work. If I try $99,99.99 numbers like 3.26 comeout as $ 3.26 which doesn't look very good. Please help.
>
>Thanks and God Bless,
>S Dyke
Tony
Skill comes from Diligence