Need page break in a large label in a GroupFooter

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!
 
D

Duane Hookom

Since the contents are static, you might try break the text into multiple
label controls.
 
B

Brad

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?
 
C

Clifford Bass

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top