to hide label in area header (1 Viewer)

murray83

Games Collector
Local time
Today, 22:31
Joined
Mar 31, 2017
Messages
728
I have a report ( hence posting in the report section ) which is populated from a query which is all fine and dandy

but now as with all things need to add to it which is fine, but it wont work as required due to the report at some point having in the Area Header a value of To Do, is there someway i can loop it. The other values are as follows

  • General
  • Sick
  • Helpdesk
  • HBW

code is below and as you can see i only want them to appear when it has To Do

cheers all

Code:
If Me.txtArea.Value = "To Do" Then
    Me.lblRaisedBy.Visible = True
    Me.lblClosedBy.Visible = True
    Me.txtClosedBy.Visible = True
Else
    Me.lblRaisedBy.Visible = False
    Me.lblClosedBy.Visible = False
    Me.txtClosedBy.Visible = False
End If
 

isladogs

MVP / VIP
Local time
Today, 22:31
Joined
Jan 14, 2017
Messages
18,186
Put the code in the format event for that section of the report
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:31
Joined
May 7, 2009
Messages
19,169
Add that code to the Detail section Format and Print events.
 

isladogs

MVP / VIP
Local time
Today, 22:31
Joined
Jan 14, 2017
Messages
18,186
Assuming you print from a preview, it shouldn't be needed in the print event as well.
If you output direct to print then do both.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:31
Joined
May 7, 2009
Messages
19,169
Still youll need it when viewed in Report view
 

murray83

Games Collector
Local time
Today, 22:31
Joined
Mar 31, 2017
Messages
728
it prints out to a pdf which is then emailed so no physical printing

i tried putting it on the mentioned places no dice shall upload and if you dont mind having a lookse

cheers

the report in question is called Systems Handover
 

Attachments

  • Handover Example.zip
    333.2 KB · Views: 107

Users who are viewing this thread

Top Bottom