MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 00:06
- Joined
- Feb 5, 2019
- Messages
- 292
Hi all,
I have a report where I want to hide/show the report footer depending on a single field. When I preview the report, the code works fine. But if I direct print, it fails, unless I have previewed it first. This is an issue when I export to PDF and email as I do not preview the report first. I have the below code in both the Format and Print event procedures.
Has anyone tried this before and managed to find an easy solution, or am I putting this in the wrong even procedure? I tried it in the footer section events, but that didn't work at all.
~Matt
I have a report where I want to hide/show the report footer depending on a single field. When I preview the report, the code works fine. But if I direct print, it fails, unless I have previewed it first. This is an issue when I export to PDF and email as I do not preview the report first. I have the below code in both the Format and Print event procedures.
Code:
If Me.txtNotes <> "" Then
Me.ReportFooter.Visible = True
Else
Me.ReportFooter.Visible = False
End If
Has anyone tried this before and managed to find an easy solution, or am I putting this in the wrong even procedure? I tried it in the footer section events, but that didn't work at all.
~Matt