fit to one page access report

[philfer]

Hi,

I have a report based on a summary query which is only two lines long.

I have another query with the detail of the summary and I have placed this as a subreport. When I print preview they are on separate pages.

Is there a way to "fit to one page" in Access

Thanks
Phil

[OBP]

Access does not have Excel's fit to page. you literaly have to make the data fit one page using Margins and Font Sizes.