Blank Lines Added To Each page Of Report

[Steve]

I am working on a report that has a subreport in the page footer. The
subreport adds blank lines at the bottom of each page.The subreport's
recordsource is a query. The query gets a parameter from a textbox in the
report's page footer. As the report's print event executes, the value in the
textbox is created. The textbox has a different value on each page; thus the
query has a different parameter value for each page and consequently, a
different number of blank lines is added to the bottom of each page. The
problem seems to be that the value of the textbox has no value when the
report first opens and consequently no blank lines are created at the bottom
of the first page. As the report goes from page to page, the subform in the
page footer does not "refresh" and therefore every page has no blank lines
at the bottom. I have a message box in the page footer that displays the
value of the textbox and the value of the parameter and they are correct. I
also have code in the page footer that opens the query and the query
contains the correct number of blank lines at each page.

Is there some code that can be added to the page footer taht will cause the
subform to display the correct number of blank lines at each page. Something
like a refresk command???

Thanks!

Steve

 

[Lynn Trapp]

Steve,

That sounds like a really "round about" way to accomplish something. It's
hard to visualize what you are trying to do. While I'm not sure how well a
subreport will work in the page footer, can you not set the subreport's can
grow property to Yes? (I'm sitting here at work trying to visualize whether
or not a subreport has a "can grow" property.) Just a thought.

 

[Steve]

Lynn,

Thank you very much for responding!

The detail section of the report is a subreport. Inside that subreport is a
record and an internal subreport. The report will not page break between the
record and the internal subreport. When a page break occurs, there is always
a blank space at he bottom of each page. My report needs to look like a
lined Invoice so I am trying to use a subreport that returns lined blank
rows at the bottom of each page.

Yes, a subreport has a "can grow" property but that doesn't help. For now, I
can't get the subreport to display any lined blank lines.

Steve

 

[Larry Linson]

That is a very unusual design, Steve, and it's puzzling to me why you'd want
to do what you describe, but not puzzling that it doesn't work for you.
And, your problem statement isn't clear, concise, and precise enough to
clarify.

Assuming you are using Access 2003 or older, I think the Page Footer does
not have a Can Grow property, so even if you set Can Grow for a Subreport
embedded, I don't see how it would "add lines". There might be enough
flaming hoops that one could jump through to accomplish what you want, if
you had the time and energy, but my suggestion would be figure out what you
really need to accomplish, and then figure out some simpler way to do it.

Larry Linson
Microsoft Office Access MVP