What do you mean with the 3.26 example, the currency signs are all aligned to the left?, I have a similar report the value get's the format "@$ 99,999,999.99", without the quotes of course, you can enter it manually or select Numeric and Currency in the format dialog; amounts come out like this:
$25.34
$1,567.45
In other words the currrency sign is displayed next to the first digit, you can make right or left justified.
On the other hand if you want something like
$ 24.34
$1,567.45
Just put the currency sign on a label next to the field..
>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