Hi,
I designed a report in DATA REPORT of visual basic 6.0 . I wish to suppress zero and print empty string when the field value contain zero in detail section. How can I do that. I have depiced a example. I need it to be done in DATA REPORT.

------------------------------------------------------------------
Name``````````````````````Credit````````Debit
------------------------------------------------------------------
Senthil```````````````````5000.00`````````0.00
Siva````````````````````````0.00``````3000.00
------------------------------------------------------------------
````````````````Total`````5000.00````` 3000.00

The above should be displayed as,
------------------------------------------------------------------
Name``````````````````````Credit````````Debit
------------------------------------------------------------------
Senthil```````````````````5000.00
Siva``````````````````````````````````3000.00
------------------------------------------------------------------
````````````````Total`````5000.00````` 3000.00


Note: where CREDIT and DEBIT fields are numeric.
Here, ` sign used to show the above report in proper alignment assume it as a space.

Waiting for the solution.

Advance thanx,

cheers,
Senthil