Memo in Report causing blank pages/other issues

  • Thread starter Thread starter shm135
  • Start date Start date
S

shm135

Hi,

I have multiple headers in my access 2007 report. I have all of the
contents of the DETAIL section set to Yes for Can Grow and Can Shrink.
One of the fields in this section is a memo field- sometimes
containing a lot of text.

I've tried setting the Keep Together option to Yes for the DETAIL
section. This causes the first page of my report to have all of the
necessary headers, but no information. On the following page, all of
the contents (including the memo) appear and accurately wrap to the
next page when necessary.

I've tried setting the Keep Together option to No for the DETAIL
section. This makes my first page appear as I would like it to (as far
as the memo is concerned). However: it cuts off data from another
textbox field in the DETAIL section and pushes that off to the next
page. I'd like this textbox field to always stay together.

Please help me figure out how I can enable keep together for all of
the fields in the DETAIL section, except the MEMO field. Is this
possible?
 
Well, sort of.  Since the KeepTogether property applies to
an entire section, you will need more sections.  You can
simulate what you want by creating a group (with header and
footer) on the field that is used to sort the report.  Then
you can spread your detail controls across this groups
header, footer and detail sections.
Click to expand...

Thanks for the response! Would this method still allow all of my
content to appear in one straight line- as if they were all in one
group? If not, do you know a way to make that work? Please let me
know. Thanks!
 
Thanks for the response! Would this method still allow all of my
content to appear in one straight line- as if they were all in one
group? If not, do you know a way to make that work?
Click to expand...

I don't think that makes sense.  If you want separate
KeepTogether so part of it is on one page and another part
of it is on another page, how can they all appear on the
same line?

The only way to get the next section to print "on top of"
("on the same line as") the current section is to add a line
of code to the current section's Format or Print event
procedure:
        Me.MoveLayout = False
Maybe using that in the group header and/or detail can get
you part way to what you asked for.

--
Marsh
MVP [MS Access]- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks again for the reply. This works perfectly for those with long
memos. However, for those with short or no memos, the content gets
over lapped. Right now, it displays perfectly, except that the notes/
memo field appears to be in a row below where it supposed to be.
Hoping to find a solution to this.
 
Back
Top