A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Force a blank page



 
 
Thread Tools Display Modes
  #1  
Old November 18th, 2005, 07:57 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Force a blank page

I have an application wherein I need to force a
blank page, sometimes at the beginning of the
report and sometimes at the end. How do I
do that?

Bill


  #2  
Old November 18th, 2005, 08:35 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Force a blank page

The same report or different reports?

You could include a page break control and turn its visible property on and
off with some vba.

Another method would be to use a blank Report Header (not the page header)
and force a page break after the Report header section.
If your report is not using the Report footer you can force a page break
after the Report footer.

Also, do you mean completely blank (no page header or page footer) or do you
mean no data between the two items.

"Bill" wrote in message
ink.net...
I have an application wherein I need to force a
blank page, sometimes at the beginning of the
report and sometimes at the end. How do I
do that?

Bill



  #3  
Old November 18th, 2005, 08:56 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Force a blank page

John wrote:
Another method would be to use a blank Report Header (not the page header)
and force a page break after the Report header section.

How does one do that? In the ReportHeader_Format? ReportHeader_Print?
Whichever the case, I don't see a command in the VBA help for that?

By blank page, I mean "like" one was going to put a separator page between
multiple copies of a printed report.
Bill



"John Spencer" wrote in message
...
The same report or different reports?

You could include a page break control and turn its visible property on
and off with some vba.

Another method would be to use a blank Report Header (not the page header)
and force a page break after the Report header section.
If your report is not using the Report footer you can force a page break
after the Report footer.

Also, do you mean completely blank (no page header or page footer) or do
you mean no data between the two items.

"Bill" wrote in message
ink.net...
I have an application wherein I need to force a
blank page, sometimes at the beginning of the
report and sometimes at the end. How do I
do that?

Bill





  #4  
Old November 19th, 2005, 02:37 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Force a blank page

Add a report header to the report
Set the Report Header's Force New Page property to After Section (on the format tab)

If you have page header and footer sections with controls that print you will
probably have to hide the controls when you are "printing" this page. That may
require vba code to run that checks the page number (Page) and hides or shows
the controls depending on the current page number.

Bill wrote:

John wrote:
Another method would be to use a blank Report Header (not the page header)
and force a page break after the Report header section.

How does one do that? In the ReportHeader_Format? ReportHeader_Print?
Whichever the case, I don't see a command in the VBA help for that?

By blank page, I mean "like" one was going to put a separator page between
multiple copies of a printed report.
Bill

"John Spencer" wrote in message
...
The same report or different reports?

You could include a page break control and turn its visible property on
and off with some vba.

Another method would be to use a blank Report Header (not the page header)
and force a page break after the Report header section.
If your report is not using the Report footer you can force a page break
after the Report footer.

Also, do you mean completely blank (no page header or page footer) or do
you mean no data between the two items.

"Bill" wrote in message
ink.net...
I have an application wherein I need to force a
blank page, sometimes at the beginning of the
report and sometimes at the end. How do I
do that?

Bill



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I cant get my report to fit on one page rmoritzky Setting Up & Running Reports 16 February 10th, 2009 01:35 PM
Report w/3 subreports - getting unnecessary/unwanted blank page Heart-of-Dixie Setting Up & Running Reports 3 September 19th, 2005 05:23 PM
Cannot force page # klam General Discussion 3 October 22nd, 2004 09:59 PM
Creating an "unmovable" blank page Dan Page Layout 1 October 11th, 2004 11:12 PM
How to delete a blank page between the pages. Suzanne S. Barnhill General Discussion 2 May 17th, 2004 11:06 AM


All times are GMT +1. The time now is 01:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.