I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.
ANy ideas as to what I can do?
Thanks Harry 6 4621 no***@here.com wrote: I have greated a report and have included a page break in it. The report breaks were it is supposed to but then it creates a blank page between the two pages. Since this report will print out approx 20 pages (without the blank pages) it is large waste of paper. I have tested the report by setting the data source so that only one page will print and all the data fits on page. I have checked all the printing parameter, set the print magins and made sure that the report fits on one page.
ANy ideas as to what I can do?
Thanks Harry
Check your page size. The fields may exceed the length of your column
(File/PrinterSetup)
Make sure your fields placement don't exceed the column width.
Hi there,
Maybe a natural page break is occurring within a line or two of your page
break control. Suggest
removing your page break control and see what happens.
HTH -Linda
<no***@here.com> wrote in message
news:72********************************@4ax.com... I have greated a report and have included a page break in it. The report breaks were it is supposed to but then it creates a blank page between the two pages. Since this report will print out approx 20 pages (without the blank pages) it is large waste of paper. I have tested the report by setting the data source so that only one page will print and all the data fits on page. I have checked all the printing parameter, set the print magins and made sure that the report fits on one page.
ANy ideas as to what I can do?
Thanks Harry
Thanks, but that was the first thing that I checked. The column size
is good and is smaller that the page width.
On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.com> wrote: no***@here.com wrote:
I have greated a report and have included a page break in it. The report breaks were it is supposed to but then it creates a blank page between the two pages. Since this report will print out approx 20 pages (without the blank pages) it is large waste of paper. I have tested the report by setting the data source so that only one page will print and all the data fits on page. I have checked all the printing parameter, set the print magins and made sure that the report fits on one page.
ANy ideas as to what I can do?
Thanks Harry
Check your page size. The fields may exceed the length of your column (File/PrinterSetup)
Make sure your fields placement don't exceed the column width.
Linda,
The does not print out any blank pages when the page break is removed.
There is group header on the report based on the field ClientNumit is
grouped on each value and keep together is set to yes. The problem is
that while most pages will seperate correctly, that is each page will
start with a new ClientNum and grouyp header, some pages will have
part of the previous page before the group header. That is why I put a
page break on the report. It solved that problem but now creates this
new one.
Harry
On Sun, 30 Jan 2005 11:48:18 GMT, no***@here.com wrote: Thanks, but that was the first thing that I checked. The column size is good and is smaller that the page width. On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.com> wrote:
no***@here.com wrote:
I have greated a report and have included a page break in it. The report breaks were it is supposed to but then it creates a blank page between the two pages. Since this report will print out approx 20 pages (without the blank pages) it is large waste of paper. I have tested the report by setting the data source so that only one page will print and all the data fits on page. I have checked all the printing parameter, set the print magins and made sure that the report fits on one page.
ANy ideas as to what I can do?
Thanks Harry
Check your page size. The fields may exceed the length of your column (File/PrinterSetup)
Make sure your fields placement don't exceed the column width.
I'd recommend losing the page break and setting your group header's
ForceNewPage property to Before Section.
<no***@here.com> wrote in message
news:7m********************************@4ax.com... Linda,
The does not print out any blank pages when the page break is removed. There is group header on the report based on the field ClientNumit is grouped on each value and keep together is set to yes. The problem is that while most pages will seperate correctly, that is each page will start with a new ClientNum and grouyp header, some pages will have part of the previous page before the group header. That is why I put a page break on the report. It solved that problem but now creates this new one.
Harry
On Sun, 30 Jan 2005 11:48:18 GMT, no***@here.com wrote:
Thanks, but that was the first thing that I checked. The column size is good and is smaller that the page width. On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.com> wrote:
no***@here.com wrote:
I have greated a report and have included a page break in it. The report breaks were it is supposed to but then it creates a blank page between the two pages. Since this report will print out approx 20 pages (without the blank pages) it is large waste of paper. I have tested the report by setting the data source so that only one page will print and all the data fits on page. I have checked all the printing parameter, set the print magins and made sure that the report fits on one page.
ANy ideas as to what I can do?
Thanks Harry
Check your page size. The fields may exceed the length of your column (File/PrinterSetup)
Make sure your fields placement don't exceed the column width.
Thanks alot.
That seems to do the trick. I will have to do some more testing but I
think it will be good.
Thanks again,
Harry
On Sun, 30 Jan 2005 12:29:27 GMT, "MacDermott" <ma********@nospam.com>
wrote: I'd recommend losing the page break and setting your group header's ForceNewPage property to Before Section.
<no***@here.com> wrote in message news:7m********************************@4ax.com.. . Linda,
The does not print out any blank pages when the page break is removed. There is group header on the report based on the field ClientNumit is grouped on each value and keep together is set to yes. The problem is that while most pages will seperate correctly, that is each page will start with a new ClientNum and grouyp header, some pages will have part of the previous page before the group header. That is why I put a page break on the report. It solved that problem but now creates this new one.
Harry
On Sun, 30 Jan 2005 11:48:18 GMT, no***@here.com wrote:
>Thanks, but that was the first thing that I checked. The column size >is good and is smaller that the page width. > > > >On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.com> wrote: > >>no***@here.com wrote: >> >>> I have greated a report and have included a page break in it. The >>> report breaks were it is supposed to but then it creates a blank page >>> between the two pages. Since this report will print out approx 20 >>> pages (without the blank pages) it is large waste of paper. I have >>> tested the report by setting the data source so that only one page >>> will print and all the data fits on page. I have checked all the >>> printing parameter, set the print magins and made sure that the report >>> fits on one page. >>> >>> ANy ideas as to what I can do? >>> >>> Thanks Harry >> >>Check your page size. The fields may exceed the length of your column >>(File/PrinterSetup) >> >>Make sure your fields placement don't exceed the column width. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: L Mehl |
last post by:
Different users of the app will want or not want to see report footer (
appears as a separate page).
I can make the section invisible with a DLookup of a Y or N value from a
'parameters' table
...
|
by: Melissa |
last post by:
Does anyone have a generic procedure for adding blank lines to reports like
Sales details, PO details and/or Orders details. The procedure would need to
count the number of line items, determine...
|
by: Nhmiller |
last post by:
Access seems to always generate a second page, which is blank, to my one page
report. How do I delete the second page? Thanks.
Neil
Cat Paintings At Carol Wilson Gallery...
|
by: Robert McClenon |
last post by:
I am having a minor but annoying problem with some reports in Access
2003. (I had the same problem with Access 97, so it isn't
version-dependent.) Some of the reports that I originally developed...
|
by: Raul Medina |
last post by:
I am trying to print the same visual basic report multiple
times in my VB 6.0 application using the command
<reportObject>.printReport False, rptRangeAllPages. The
only thing that differs between...
|
by: Karen Hill |
last post by:
X-No-Archive:yes
I have a report that when I view it gives me a blank page after a page
with data. For example in the footer, it says I have 2 pages (page 1
of 2), yet when I use the arrow key...
|
by: jj |
last post by:
I created a dynamic report and the fields is displayed
base on the query. The report contains about 34 fields so if the query has
34 fields, all
34 fields in the report shows up. But if the query...
|
by: Mal Reeve |
last post by:
Hello,
I have a report that has only 2 levels of grouping.
The detail section is simply 1 large block for a memo field.
I am finding that on some occasions the report errors and generates...
|
by: maryanncanor |
last post by:
Hi everyone,
My problem is whenever I export a report to a textfile. The output textfile have blank spaces.
Here is my query:
SELECT ( & '|' & & '|'...
|
by: lllomh |
last post by:
Define the method first
this.state = {
buttonBackgroundColor: 'green',
isBlinking: false, // A new status is added to identify whether the button is blinking or not
}
autoStart=()=>{
|
by: DJRhino |
last post by:
Was curious if anyone else was having this same issue or not....
I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: Teri B |
last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course.
0ne-to-many. One course many roles.
Then I created a report based on the Course form and...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)
Please note that the UK and Europe revert to winter time on...
|
by: nia12 |
last post by:
Hi there,
I am very new to Access so apologies if any of this is obvious/not clear.
I am creating a data collection tool for health care employees to complete. It consists of a number of...
|
by: isladogs |
last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, Mike...
|
by: GKJR |
last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
| |