Print form in Landscape

[dmyoungsal]

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

 

[CJ_London]

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

 

[CJ_London]

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

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