A
adgorn
In the detail section of a report called Payment Receipt , I display the
result of a query, Expr2, in a text box. (This will be a number (dollar
amount) that is different for every record. FYI the text box is also called
Expr2.) If that value = 0, I do not want the page footer to display. So I
used the following code in OnFormat for the detail section:
If [Reports]![payment receipt].[Expr2] = 0 Then
[Reports]![payment receipt].[Section](4).Visible = False
End If
It doesn't work. Any help? Thanks.
result of a query, Expr2, in a text box. (This will be a number (dollar
amount) that is different for every record. FYI the text box is also called
Expr2.) If that value = 0, I do not want the page footer to display. So I
used the following code in OnFormat for the detail section:
If [Reports]![payment receipt].[Expr2] = 0 Then
[Reports]![payment receipt].[Section](4).Visible = False
End If
It doesn't work. Any help? Thanks.