No I don't have a printer on this machine. I never thought of that.

I have since chosen a printer and set the print area to A1:J500.
Didn't help

Where do the automatic page breaks derive from? It seems not to be
able to figure out where to add them either.
I get a long 500 row sheet in preview.
All pagebreaks don't show and no new ones are adding with any visible
cue.

In TOOLSOPTIONSVIEW the under Window Options PageBreaks option is
disabled I notice. (if I am in PageBreakPreview mode)
changing it in Normal view doesn't change things.


I am sure this must be something I have done. I just don't know what.

Thanks to anyone with an idea.
..


you do have a printer defined and selected, yes?

--
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