Visible Fields in Report if field=x

[chris.williams]

Hello all - I have a report with a subreport which displays a list of configuration items for a parent record.



In the sub report, I want to hide several fields on records which have a field value equal to "x".

I thought about the onload event, but that is not hiding the fields which should not show up. Any thoughts?

[Bob Fitz]

Perhaps you need the On Format event.

[chris.williams]

On Format does no show up as valid selection for reports. Any other suggestions?

[Bob Fitz]

I think you'll find it is a section (Header, Detail, Footer etc) event.

[chris.williams]

I see it now. Unfortunately, that does not work. Here is the code which is placed in the "On Format" event where these object reside:

If IsNull([RIDCert]) Then
Me.TextRIDCert.Visible = False
End If

[RayMilhon]

change your If statement slightly

If IsNull([ridcert]) then me.textRIDCert.visible = False Else me.textRIDCert.visible = True

[Bob Fitz]

Insert the line below to test that the code runs when the report opens. After opening the form inspect the immediate window for "No Value"
If IsNull([RIDCert]) Then
Debug.Print "No Value"
Me.TextRIDCert.Visible = False
End If

[RayMilhon]

Sorry had to rush on my previous response due to work. In the If statement you posted which I'm presuming is in a group section or detail section as soon as the first record that evaluates to true sets the textbox to visible = False. It's never changed back so for every record after that even if the textbox should be there it won't. You need to make sure that you set it back to visible = True when it should be there. For that reason you add the else statement. Sincethat's the only thing your changing you can do it in 1 line of code as I posted. If you have multible options you would have to format it like bob showed

If IsNull([RIDCert]) Then
     Debug.Print "No Value"
     Me.TextRIDCert.Visible = False
Else
     Debug.print "Some Valule"
     me.txtRidCert.visible = True
End If

*Note: I'm making a presumption here as you do not actually specify exactly what's wrong. This is just what I noticed in your post

[chris.williams]

I have a few statements in there an some are working now. I will take what you guys recommended and run with that. Thank you.