Make fields appear or disappear

[Sess]

I need to hide or unhide things on a report so I was going to set some fields to Visible = False and then turn them to visible if the criteria is met. I did this on a form in the OnLoad event and it works how I like it (hope that is the best place to put it).

If Me.MACHMODCOV = "LINE A" Then
Me.FluxA.Visible = True
Me.FluxB.Visible = True
EndIf
If Me.MACHMODCOV = "LINE B" Then
Me.FluxD.Visible = True
Me.FluxE.Visible = True
EndIf
If Me.MACHMODCOV = "LINE C" Then
Me.FluxF.Visible = True
Me.FluxG.Visible = True
EndIf

What I would like to know is to put it into a report what event would I use?
Thank you.

 

[SOS]

It would go in the On Format event of the section those are in.

 

[Sess]

Worked like a dream in the Detail section of the report - thank you!

 

[Khalid_Afridi]

SOS is Great!