Need page break in a large label in a GroupFooter

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

I need to create a letter which has varying lines of detail information near
the top of the page. After this detail information I need to print a block
of static text.

I have this block of text in a Label in the GroupFooter section. If there
is only a small amount of variable detail lines, the text in the Label in the
GroupFooter prints nicely on the bottom of the page.

However, if there are several lines of detail (thus pushing down where the
Label can start), the entire Label is printed on a second page, leaving way
too much blank space at the bottom of the first page.

I want to have as much of the text as possible in the Label printed on the
first page and then have a page break and print the remaining text on a new
page. In the properties for the Footer, I have "Keep Together" set to "no"
and "Force New Page" is set to "None". Thanks in advance for any advice you
may have to offer. I am really pulling my hair out!
 
Since the contents are static, you might try break the text into multiple
label controls.
 
Duane,

Thanks for your help, I appreciate it. You are right, breaking the text
into multiple label controls will indeed get the job done. I may use this
method.

I was hoping for a way to tell Access to break to a new page in the middle
of the big block of text, when the first page was full. This could occur
almost anywhere within the big block of text.

Brad

PS. I am new to Access and to this Discussion Group. What does MVP stand
for?
 
Hi Brad,

Alternatively, instead of labels, you could use a text box with it's
control source set to:

="Your long label text..............."

That should be able to break dynamically.

Clifford Bass
 
Back
Top