Memo in Report causing blank pages/other issues

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

 

[Marshall Barton]

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.

 

[shm135]

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.

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!

 

[Marshall Barton]

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?

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.

 

[shm135]

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?

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 -

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.

 

[Marshall Barton]

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.

What data do you have in the detail's group header, the
detail and group footer sections?

Did you use the MoveLayout line? If so which sections?

What do you mean by "the content getsover lapped"? I think
the memo field has to be in the group footer section and can
not use MoveLayout. Also, the group footer section must
have it's design height the same as the the taller of the
other sections and can not use the CanShrink feature.