Tricky report requirement - “Record Header†that prints once.

[h2fcell]

I have a tricky report requirement with 2 issues I can’t seem to resolve.

First issue is related to lines not always printing in the detail section of
a report. The detail section of the report contains a memo field from a
table. I have vertical lines on the left and right sides of the memo field.
The goal is for the lines to print the length of the detail section on every
page of the report. If the memo is long enough to require continuation on a
second page, the lines do not print on the second page. How can I get those
lines to continue?

Second issue is related to a header requirement on the same report. I’m
using the Page Header section to print the Memo’s Text ID on the top of the
page. When the above case of a long memo requires a second page I don’t want
the Memo’s Text ID on that second page for that record with a long memo.
If the report were pulled for one record at a time I could use the Report
Header section for the Memo’s Text ID but the report is pulled for multiple
records at a time.

What I really need is a “Record Header†section that will print once for
each record. I’m using Access 2007 and would like to know if what I
described is possible. Any help is appreciated.

 

[Marshall Barton]

I have a tricky report requirement with 2 issues I can’t seem to resolve.

First issue is related to lines not always printing in the detail section of
a report. The detail section of the report contains a memo field from a
table. I have vertical lines on the left and right sides of the memo field.
The goal is for the lines to print the length of the detail section on every
page of the report. If the memo is long enough to require continuation on a
second page, the lines do not print on the second page. How can I get those
lines to continue?

Second issue is related to a header requirement on the same report. I’m
using the Page Header section to print the Memo’s Text ID on the top of the
page. When the above case of a long memo requires a second page I don’t want
the Memo’s Text ID on that second page for that record with a long memo.
If the report were pulled for one record at a time I could use the Report
Header section for the Memo’s Text ID but the report is pulled for multiple
records at a time.

What I really need is a “Record Header” section that will print once for
each record. I’m using Access 2007 and would like to know if what I
described is possible.

I haven't tried it A2007, but the lines for a CanGrow
section can be done using VBA code in the section's Print
event:
Me.Line (10,0)-Step(0,20000) ' Left side
Me.Line (Me.Width-10,0)-Step(0,20000) ' Right side
not sure the 10 is really needed.

You can get a "detail" header by using Sorting and Grouping
(View menu) to create a group with header on the same fields
you are using to sort the report's detail records.

 

[h2fcell]

Marsh,
You are the man! Thank you very much for the Me.Line info.
I actually added the code to the "On Page" event so that the lines appear
the length of the report. I haven't played around with the Sorting and
Grouping yet but I'm sure that's where I have to be.

Thanks again.