How Do I Print a ReportTitle Page on Right Side of Landscape A4 Page

[p51m]

I am trying to generate a classroom report for my wife's school using Access 97. The report is in book-type format on a landscape A4 page (2 report pages per A4 page). I can get the data to print correctly on both sides of the page using landscape in page setup with 2 columns, and using a main report for the report title with the data displayed in a subreport. The book report needs the title page printed on the right side of the A4 page to correcly collate into the book pages. My problem is no matter how I fiddle with the report header formatting, it will only print on the left side of the A4 page. If I try to force it to print on the right side, it pushes to a new page, again displaying on the left side. I am relatively inexperienced in Access, particularly when it comes to coding. I have checked the FAQs and the Access Report threads, without an obvious lead. Any suggestions or advice would be very much appreciated.

 

[nberryman]

Try inserting a Label the width of the page and right aligning the text.

The label will start at the left but as it's right aligned you should be able to control the position by re-sizing the text

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[p51m]

Thanks very much, Neil, for your suggestion, which led me to resolving the problem.
Embarrassingly, the solution was even simpler. Although I had set page layout to landscape, I had not set the page width wide enough in design view to accommodate the landscape layout. When I made the page wider, I could set the text where it needed to go. Live and learn!