AutoHide Column in Report

[Jayessh]

I am making a Database for Payroll, I have a Report SalarySheet and I need a Column Say Bonus, but The Column Bonus will have values in only Once in a Year. i.e. it will have value in only for one Months Salary Sheet Rest 11 months it will remain empty and unnecessarily occupy space.



I need a Column which will auto hide with his Lable (Tile of the Field) when it has Zero in all the month and will show only when it has some value in any record

My Report is Tabular Format
Grouped
and based on Query

I ma using MS Access 2007

Try to give solutions in Expression Builder, codes are so complicated, even if not possible Code will done

Please give me some hint or solutions

Thanks in Advance as I know all your guys are experts of Access

[ranman256]

set the design property of the rpt, set txtbox.visible =false
then when it has a value it will become visible.

in the detail ON PRINT event:

on error resume next
txtBox.visible = txtbox > 0

[Bob Fitz]

Cross-Posted: https://www.access-programmers.co.uk...report.314650/

Please read: https://www.excelguru.ca/content.php?184

[Welshgasman]

Cross-Posted: https://www.access-programmers.co.uk...report.314650/

Please read: https://www.excelguru.ca/content.php?184

With 16 posts no less as well.?

[Bob Fitz]

With 16 posts no less as well.?

Judging from the comments in post# 16 it's not going too well
I don't think I'll get involved