Fit to print will ignore pagebreaks. But scaling alone should not. Fit to
print will put a number in the scaling textbox, but that just shows you what
Fit to print will use for scaling (it doesn't mean you are using scaling as
your method of printing - scaling would need to be selected specifically and
then fit to print would not be selected since these are option buttons).

--
Regards,
Tom Ogilvy

"nope" wrote in message
...
Thank You Tom,
I am trying to present the page at 75%.
I do see PAGE1 showing but no others. I see what you mean about a page
holding 65 rows but I don't even see a page break at row 2 if I set it
there. if I manually set a pagebreak nothing seems to happen at all.
I am sure it is just to many hours of me thinking about this the wrong
way.
More tomorrow I suppose.

Thank you again.
ScottD
If you don't use scaling or fit to print, then you should see the number
of
pages. Just remember that if the page can only hold 65 rows and you put
a
page break at 75 rows, you will get an automatic pagebreak at 65 rows and
your manual pagebreak at 75. That is just a fact of life. The printer
selected along with margins and so forth will dictate what can fit on the
page.

--
Regards,
Tom Ogilvy

"nope" wrote in message
...
Ok I found it is related to Page Setup. it was set at 1 page wide and
1 page long. I adjust manually and it displays differently. How do I
change the PageSetup to reflect the correct qty of pages? I thought
changing things by inserting PageBreaks was enough in code.

ScottD

If you try enough you eventually figure out what you wanted to blame
on something else was you.

--
Regards,
Tom Ogilvy

"nope" wrote in message
...
Thank You Tom.
I have set a printarea range of "a1:J500" (this changes and is set
in
code although J is the absolute right column)
and the pagebreaks don't appear in pagebreakpreview although they
are
set by designating
A3 or A130 or A222 as the location to insert them.
Of course the actual area to insert them changes based on the row
location of a calendar week header postion.
Appreciate your input

ScottD




PageBreak preview mode

if you set a printarea that doesn't include your pagebreaks, then
they
wouldn't appear in this view. Only pagebreaks that are within the
white
area.

--
regards,
Tom Ogilvy


"nope" wrote in message
...
I have been working on adding pagebreaks within some report
results
sheets.

Everything indicates that they are being created correctly and I
have
been able to run some things which show they they are there,
thanks
to
some good examples from all you folks.

However on screen in PageBreak preview mode no page breaks are
visible
except the exterior boundaries of the PrintArea.
Is the set PrintArea doing this?

I have never been much involved in the printed output of reports.
Thank You,

ScottD