I am using Access 2017 and have built an DB using Navigation Forms, horizontal tabs and vertical tabs left. Main form is named 'Home' with default subform name of Navigation Subform. I can print a report straight to the default printer. I can show a print preview of a report in the Navigation Subform. However, how do I then print the report to the printer. A print command button placed in the report header does not show in print preview but does show in layout mode. Layout is not available when you run the DB! The print ribbon, of course is not available in navigation forms. Any help would be appreciated.
Solved it. On the vertical tab used to open the report in report view
Private Sub PrintSignupRepBut_Click()
DoCmd.OpenReport "LTSwimSignupFormReport", acViewReport
End Sub
Then on the print button on the report I used:
Private Sub PrintButtonOnReport_Click()
DoCmd.OpenReport "LTSwimSignupFormReport", acViewNormal
End Sub
Seems to work fine and is a simple solution.
Solved it. On the vertical tab used to open the report in report view
Private Sub PrintSignupRepBut_Click()
DoCmd.OpenReport "LTSwimSignupFormReport", acViewReport
End Sub
Then on the print button on the report I used:
Private Sub PrintButtonOnReport_Click()
DoCmd.OpenReport "LTSwimSignupFormReport", acViewNormal
End Sub
Seems to work fine and is a simple solution.
Last edited: