How to print reports as seen on preview

[Mackooo]

How to print the report exactly as you see on preview.

I have a report where In the detail section I have a subreport which is based on a query from the main report. I have page break function in this subreport which inserts a page after 12 records. Secondly, I have a pagefooter, which is visible on the first page only. This works fine on the preview and when I print the report it does not show the page footer section on either of the pages.

Please help

 

[dhookom]

I have never seen page events, controls, or sections show or have any effect in subreports. This includes print preview or print.

You normally are faced with finding a solution that doesn't include page stuff in subreports.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ZmrAbdulla]

dhookom,
You might have noticed..
This thread is a continuation of
How to restrict page footer on other pages
thread703-1153627



________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.