printing overgrowth on new page.

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I want a memo field to print on a seperate page by itself
if it gets larger than a certain size. I was told some
vba code would have to be written, unfortunately I dont
know what the code should be. Can anyone help? Thanks
in advance.
 
Randy said:
I want a memo field to print on a seperate page by itself
if it gets larger than a certain size. I was told some
vba code would have to be written, unfortunately I dont
know what the code should be.
Click to expand...


I don't think any code is needed. Create a group level
(View menu - Sorting and Grouping) below any existing
sorting or grouping on the detail record's PK field. Set
the group level's Header and Footer to Yes. (Note that is
you were relying on some other mechanism to sort the data,
this will override it so you'll have to specify that here
too.)

Now you can spread out the detail section's controls over
the three sections with the memo field's text box in a
section by itself. Set that section's KeepTogether property
to Yes.
 
Back
Top