to hide label in area header

[murray83]

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

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]

Put the code in the format event for that section of the report

 

[murray83]

Put the code in the format event for that section of the report

shall try it right now

 

[arnelgp]

Add that code to the Detail section Format and Print events.

 

[isladogs]

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]

Still youll need it when viewed in Report view

 

[isladogs]

Fair enough - I never use report view.

 

[murray83]

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