Printing some report detail on a seperate page

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

This is what I want to do. If a field in the detail
portion of the report gets bigger than a certain amount
of characters then print that field's info on a seperate
page by itself. Can't seem to figure this one out.
 
This is what I want to do. If a field in the detail
portion of the report gets bigger than a certain amount
of characters then print that field's info on a seperate
page by itself. Can't seem to figure this one out.
Click to expand...


Add two Page Break control to the detail section, one just above the
field in question, the other just below it.

Code the Detail Format event:
PageBreakName1.Visible = Len([Fieldnname]) >5000
PageBreakName2.Visible = Len([Fieldnname]) >5000

Change the 5000 to whatever you feel you would need.

If, in addition to printing the field on it's own page, you do NOT
wish to show the Page Header (and/or Group Header, if you have one) on
that page, code each of those sections Format event:

Cancel = PageBreakName2.Visible
 
Back
Top