OnFormat event in report detail is hiding a field on ALL records (vs individual records)

[ChrisCione]

I have the following code as an On Format event for the detail section of a report.

If Me.txtReferralReturnedDate = Null Then
    Me.txtReferralDueDate.Visible = True
Else
    Me.txtReferralDueDate.Visible = False
End If

The report returns multiple records, making the txtReferralDueDate field NOT visible for ALL records even if only one record contains a txtReferralReturnedDate that is Null.

Obviously, I've done something wrong and appreciate any help.

 

[stumac]

Are you viewing the report in 'Report View' or print preview?

The onformat runs in print preview.

There are a few ways to do what you are looking for in report view, Conditional formatting without code might work for you.

 

[ChrisCione]

Print preview and print. It's rendering that particular field NOT visible for all records, despite some records meeting the first condition. I'm stumped beyond stumped.

 

[stumac]

I think access doesn't have nulls as date values, try comparing to 0:

If NZ(Me.txtReferralReturnedDate) = 0 Then
    Me.txtReferralDueDate.Visible = True
Else
    Me.txtReferralDueDate.Visible = False
End If

 

[ChrisCione]

Success! Thanks for your help.