I have a large application that sends print lines to a table along with non-printed sorting and control fields. After the app runs, users can use turnkey form choices to push all or part of the table to several Access reports. As this is a conversion of a legacy application, I am preserving the form and logic of the original.
It is also important that I control page breaks. There is a Boolean field in the table (fPageBreak) which if true, causes a conditional field to become visible and punches out a break:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me![fPageBreak] Then
Me![CondPgBreak].Visible = True
It works great. However, all the reports are in portrait orientation, and I'd like to spin a few pages 90 degrees for length. Is there a way, for example, VBA code I can use behind the report, say, with a new field fLandscapeOn, which, if TRUE at the time of a page break, can change the report orientation until directed otherwise or finished, to do this?
I know I can create separate reports and direct the prints as appropriate, but that will get unwieldy in a hurry and this, if possible, is a better fit.