<div>
In the ribbon, Print Preview tab, you can switch between portrait and landscape.<br />
<br />
OM Gang
</div>


In the ribbon, Print Preview tab, you can switch between portrait and landscape.

OM Gang

<div>
In design view it's the Page Setup tab on the ribbon.<br />
<br />
OM Gang
</div>


In design view it's the Page Setup tab on the ribbon.

OM Gang

<div>
What is stated above is if you want to &quot;Print&quot; the report in Landscape.<br />
<br />
Obviously, there is no utility that will magically Change the &quot;design&quot; of the report to fit more nicely in landscape mode...<br />
<br />
If this is what you really need (change the actual Design of the report to landscape) then you will have to do this manually (in design view), ...Or simply use the Report wizard to create the report with a landscape orientation.<br />
<br />
JeffCoachman<br />

</div>


What is stated above is if you want to "Print" the report in Landscape.

Obviously, there is no utility that will magically Change the "design" of the report to fit more nicely in landscape mode...

If this is what you really need (change the actual Design of the report to landscape) then you will have to do this manually (in design view), ...Or simply use the Report wizard to create the report with a landscape orientation.

JeffCoachman


<div>
And bear in mind that Access (annoyingly!) doesn't show you the margins in report design mode, so you have to check in preview whether your controls are going outside the margins. &nbsp;Otherwise you will find out when you print, and every other page has a little text in the left margin (those are the controls that went outside the margins).
</div>


And bear in mind that Access (annoyingly!) doesn't show you the margins in report design mode, so you have to check in preview whether your controls are going outside the margins.  Otherwise you will find out when you print, and every other page has a little text in the left margin (those are the controls that went outside the margins).

<div>
omgang: which ribbon had the Page Setup - I cannot find it
</div>


omgang: which ribbon had the Page Setup - I cannot find it

reportdesign.jpg

<div>
Another shot<br />
OM Gang <a href="https://filedb.experts-exchange.com/incoming/2011/10_w41/509509/reportdesign1.jpg" target="_blank" title="report design (96 KB)"><img alt="report design" class="file-block lazyload" style="max-width: 720px;" data-src="https://filedb.experts-exchange.com/incoming/2011/10_w41/509509/reportdesign1.jpg" /></a>
</div>


Another shot
OM Gang report designhttps://filedb.experts-exchange.com/incoming/2011/10_w41/509509/reportdesign1.jpg

reportdesign1.jpg

<div>
Screenshot helped a lot thanks - didn't realize there were &quot;submenus&quot; in the ribbon.
</div>


Screenshot helped a lot thanks - didn't realize there were "submenus" in the ribbon.

<div>
<div class="content wysiwyg-content">
In Access 2007 where do I go to change a report layout to landscape?
</div>
</div>


In Access 2007 where do I go to change a report layout to landscape?

Report Landscape View

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.