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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subreport label stays visible 4
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Conditional formatting on a label? 3
hide label in subreport within report 7
Expression Builder query with zero amounts 5
Difference between using a hidden field and a label that is not visible. 3
Accessing invisible control in Javascript 3
CheckBox Outside DataList & Labels Inside DataList 1

Back
Top