Conditional Formatting of Access 2007 Report Header
Posted on 2014-01-29
I am trying to apply a OnFormat condition to a low level report header. Basically, if the header field does not have a value, I want to suppress display of all the header fields. The Onload code is:
Private Sub GroupHeader4_Format(Cancel As Integer, FormatCount As Integer)
If (Len(Nz(Me.CAUS_ID, "")) > 0) Then Me.GroupHeader4.Visible = False
' If IsNull(Me.CAUS_ID) Then Me.GroupHeader4.Visible = False
' If IsEmpty(Me.CAUS_ID) Then Me.GroupHeader4.Visible = False
The GroupHeader4 and fields still display. Note from the commented code that I have tried several ways to detect a null field value, but to no avail.
This is a very large report and there are only about 10% of the records with a CAUS_ID that would have additional data. Attached is a sample of what the report looks like.
Appreciate any help!