Hello,
Recently I created a report with text boxes that were visible only if not null. I also made the page header labels invisible if the detail text boxes were null. This worked fine when dealing with records of the current year.
When combining records from prior years, I noticed that the page header labels appeared only if the first text fields of the columns were not null. If the first field was null then no label, even if the second field in the column was not null.
My code is :
If IsNull (Me.SumOfFeb) Then
Me.LblSumOfFeb.visible= False
Else
Me.lblSumOfFeb.visible=True
End If
I put it in ON FORMAT of the page header.
Is there a way to correct this problem?
Recently I created a report with text boxes that were visible only if not null. I also made the page header labels invisible if the detail text boxes were null. This worked fine when dealing with records of the current year.
When combining records from prior years, I noticed that the page header labels appeared only if the first text fields of the columns were not null. If the first field was null then no label, even if the second field in the column was not null.
My code is :
If IsNull (Me.SumOfFeb) Then
Me.LblSumOfFeb.visible= False
Else
Me.lblSumOfFeb.visible=True
End If
I put it in ON FORMAT of the page header.
Is there a way to correct this problem?
