Thank you.
By the way how will this work in Reports?
There are check boxes for CR if Positive DB if negative or i just have to use TRANSFORM() ?


>>>What exactly do you mean here?
>>
>>A word to the wise. :)
>>
>>In TRANSFORM we can format the data.
>>
>>@C Appends CR to positive Currency or Numeric values to indicate a credit.
>>
>>@X Appends DB to negative currency or numeric values to indicate a debit.
>>
>>I want DB to be DR which is standard for Debit at least in accounting books.
>>How can i achieve this in VFP?
>
>

>? CHRTRAN(TRANSFORM(-1231,[@X]),[B],[T])
>