Rodd,
Left justify the field. (You may have to use a fixed font)
___________________________
>I've created a report that displays a description of an account and it's balance. I've got the amount balance field formatted with @CX 999,999,999.99. The field is not left justified.
>
>My problem is when I hit an account with a 0 balance. Because no DB/CR sign prints, the 0.00 is right justified and doesn't line up with the rest of the amounts in the column. For example:
> 123,123.00 CR
> 1,122.00 CR
> 0.00
> 3.00 DB
>
>
>Is there any way to get the following:
>
> 123,123.00 CR
> 1,122.00 CR
> 0.00
> 3.00 DB
>
>
>Thanks for your help.
>
>Rodd
Gregory