View Full Version : Make fields appear or disappear


Sess
03-15-2010, 11:15 AM
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
03-15-2010, 11:18 AM
It would go in the On Format event of the section those are in.

Sess
03-15-2010, 11:53 AM
Worked like a dream in the Detail section of the report - thank you!

Khalid_Afridi
03-21-2010, 04:18 AM
SOS is Great! ;)