Hiding & showing a label in a report using a toggle button in a form

  • Thread starter Thread starter frunkablunka
  • Start date Start date
F

frunkablunka

Does anybody know how to hide & show a label in a report using a toggle
button in a form?

What I am trying to achieve is displaying some text on a label in a
report when a toggle button in my main form is pressed down. When it is
in the upstate I want the lable to be invisible on the report.


How do I achieve this?

Please :)

My form is called frmProject
My report is called rptJobOverview
My toggle button in frmProject is called tgbTrack
My label in rptJobOverview is called lbltrack

Thanks
 
Basically, you need code like the following. You should be able to place
that code in the reports open event

Private Sub Report_Open(Cancel As Integer)
Reports!rptJobOverview!lblTrack.Visible = Forms!frmProject.tgbTrack
End Sub
 
Back
Top