Removing 0.00 from report 2

[ajay30in]

Hi Friends,
I have made a access report of Bank Transaction, which have 2 text boxes having Standard Currency Property, viz. Deposit and Withdrawl, and other calculated control called Balance, which have Running Sum property,which runs like this, =[deposit]-[withdrawl] and shows current Balance, now in any transaction there is either Deposit or Withdrawl, i.e if it is deposit of 1000.00 then withdrawl show 0.00, so I wants to hide the 0.00 value in my report, if it is >0.00 then only it should be visible, please help, Thanx.

 

[Maquis]

In the on_format event of the report you can put this code:

If me![Withdrawal] > 0 then
me![Withdrawal].visible = true
else
me![Withdrawal].visible = false
end if

ditto for me!deposit


That should do it for you. Maq B-)
<insert witty signature here>

 

[VogonPoet]

You can do this without code by using the format property of the control. Something like this:

#,##0.00 ;(#,##0.00); ;

This will suppress the 0.00 values

 

[ajay30in]

Thanks guys, I am really surprised by your response, I am greatful to you and

http://www.tek-tips.com

Thanks again and great going.