Sorry the message didn't format properly. The idea is The $ all line up and the decimals all line up, making for a neat appearance in a grid cloumn.
>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