Report Labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make a label visible or invisible in a report, for instance, if the
total at the bottom of an invoice is a minus amount, I want to make a label
in the heading "Credit Note" visible but when plus amount invisible. and
where do I put the VBA to do that
 
Add VBA code to the Print Event of the relevant section.

Me!NameOfYourLabel.Visible = Not(Sum(Total) > 0)
 
Back
Top