Controlling page breaks with variablelength text

[motaman]

I am printing a report that has many memo field components sprinkled in with other sets of related responses, both text and graphics. <br>
My problem is I get inappropriate page-breaks, because I don't know how long the previous text entries are. <br>
Is there some way I can group a few related area's together and have a pagebreak occur if the entire 'group' can not be printed on one page, but no pagebreak if they do fit?

 

[DougP]

Did you look at sorting And Grouping under the View Menu<br>
You can specify Page breaks before or after each group<br>
Experiment with it to see which you like. <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[motaman]

Hi Doug,<br>
Thanks, but I have already tried that, this is not a group as defined by access, it is sort of a subgroup of questions within the detail of the main report. <br>
I was trying to avoid sub-reports, I already have about 20 subreports in this main report, and I am trying to simplify the design (ROFL)... <br>
I am looking for some sort of 'group together' functionality like you find in graphics packages. Does that spark any other ideas?

 

[Geekette]

you could try creating a string that concatenates the various memo fields:<br>
1) create an unbound text box<br>
2) control source =[messymemofield1]&&quot; &quot;&[messymemofield2]&....<br>
(you might want to play around with the spacing, depending upon the contents of the fields)<br>
<br>
3) set the text box to &quot;can grow&quot;<br>
<br>
you might also consider using columns which might make the appearance more pleasing to the eye (text would flow up and down and people wouldn't be as aware of &quot;orphan&quot; text)