Print form in Landscape (1 Viewer)

I have a form that is used to do onetime calculations that I need to print.

The issue is my form is a bit wider than will fit on a portrait page and I need to print it landscape. I am using a Event Procedure presently to print the screen and it prints fine, except for the fact that it bleeds over to two pages. If I manually got into setup, I can change the orientation to Landscape and it is all good.

Your suggestions are most appreciated.

Thank you

I'm assuming when you say, print the screen, you mean print the form.

Assuming this is correct - it depends on the version of access you are using, but with 2010 do the following:

1. Open the form
2. select File>Print>Print Preview
3. In the ribbon, you should see the layout options - select landscape.
4. you may want to adjust margins as well to center it
5. close the form

Next time you open it and print it should be landscape

other thought if you are doing this in code, you would use something like

Me.Printer.Orientation = acPRORLandscape
DoCmd.PrintOut , 1, 1, , 1