Report View - visible IF

[thr33xx]

Hello,

I am working on a report in which I have 2 fields in the detail section. The field names are "Status" and "Citation".

When viewing the report, IF the status = "Published" THEN I would like the Citation to be visible, ELSE the citation should be hidden.

I was able to get the print preview to work using the code below in the On Print property, but I am unable to get it to work under the Report View. It only works when print preview.

If Me.Status = "Published" Then
        Me.citation.Visible = True
    Else
        Me.citation.Visible = False
End If

Any ideas?

 

[Severin]

if there's only one record you can use Report_Load and OnPrint (or isn't it Report_Page) but if there's more then you have to use conditional formatting and just make the letters white!~)

 

[thr33xx]

Sorry, I forgot to clarify. There are multiple records on this report.

The above method I mentioned does work on the multiple records. Where it will hide if the status is not published, and show if published.

I just can't get it to work in the Report View.

 

[thr33xx]

Any ideas guys?

This works for print preview, but not for report view.