Section Breaks in a Report

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Thanks in advance for any insight, advice, or direction
anyonre might be able to provide.

I have a very simple report with two columns that prints
very nicely. I have now been asked to include a
report "cover page" for this report.

I can include all the text/information I need in the
report header section, and then put a page break after,
but then how can I make sure the report header prints in
one column and then the detail section prints in two
columns? Kind of the way a "section break" works in
Microsoft Word.

Right Now.... I have these as two separate reports, with a
command button on a form that sends each of these two
reports to the printer consecutively. Ok, it works, it
gives then what they need, but being allowing the use
to "preview" everything on the screen as one report is
optimal.

Is there any column property, or PageSetup property in
Access VBA that I can't seem to find.

Thanks again for any direction you might be able to lend.

Don
 
I don't fully understand your question without looking at the report. But I
guess that you have to move the report heading down; you may have the
heading in the report section now.
 
Sorry for the poor explanation....

Well....

The "width" of the report is only about 3.5" inches.
I went to Page Setup under the File Menu, clicked on the
columns tab, and set the report to two columns. The data
in my feilds is not very long. The report prints nicely.

But now, I want to print a "cover sheet" that spans the
entire page. I obviously can't do this if the width of
the report is only 3.5" inches.

So, I was wondering if there was a way via VBA to change
these settings.

Pagesetup, Numbers of columns, ReportWidth, etc.

I saw columnCount, but that appears to be the number of
coumns in a list box.

Thanks Again.......
 
I can do this by setting the page setup as follows:

Number of Columns: 2
Column Size: 3.75
Same as Detail: UNCHECKED

I use the REPORT header section to contain the "Cover Sheet". It only prints
once per report and you can print this on a separate page.

Why do you need to do this in code? Do you need to hide the Cover Sheet on
occasion? That can be done with the section's visible property.

If you need to do this in code, check out PrtMip property and PrtDevMode
property and the PrtDevNames property. I don't use these properties myself, so
I don't know that I can help you any further than by pointing you to the help files.
 
Hi Don,

I think all that you need to do is to drag your report
width out to 6.5" or so (depending on your margins) and
enter your report and/or page headers. Just leave your
detail section as it is. I believe that the column
setting only affects the grouping and detail sections,
not the page/report header/footer.

I have reports that do this, but if it doesn't work for
you for some reason, you could also try inserting your
columnar report as a subreport to a non-columnar report.

HTH

-Ted Allen
 
Back
Top