You're welcome
All my reports use Courier New for currency types.
To make it more visible use Courier New Bold (you can hardly see the normal Courier New on the printed paper)
I did not find any other way. Right align does an rtrim() I guess
Had the problem in the past with (NegativeNumbers) [ @B( 999,999,999.99 ]
__________________
>Well,
>Not quite the answer I was hoping for but it did work. Thanks for your input. The rest of my report uses Arial so it looks a bit hokey with one column using Courier New ... but I guess less hokey than zeros printing out with the CRs and DBs.
>
>I can't think of any reason why someone would want the 0's to line up in the CR/DB column as opposed to lining up with the rest of the numbers. Maybe the Fox Team could pad a couple spaces at the end if there is a zero value or something.
>
>Rodd
>
>>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