Prev: Unbound Calculation populates from 3 seperate fields
Next: Deleting page headers on pages w/o records
From: shm135 on 26 May 2010 14:58
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?
From: Marshall Barton on 26 May 2010 18:21
shm135 wrote:
>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.

--
Marsh
MVP [MS Access]
From: shm135 on 27 May 2010 01:07
On May 26, 6:21 pm, Marshall Barton <marshbar...(a)wowway.com> wrote:
> shm135 wrote:
> >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.
>
> --
> Marsh
> MVP [MS Access]

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!
From: Marshall Barton on 27 May 2010 08:58
shm135 wrote:

>On May 26, 6:21�pm, Marshall Barton <marshbar...(a)wowway.com> wrote:
>> shm135 wrote:
>> >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.
>>
>
>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]
From: shm135 on 28 May 2010 13:19
On May 27, 8:58 am, Marshall Barton <marshbar...(a)wowway.com> wrote:
> shm135 wrote:
> >On May 26, 6:21 pm, Marshall Barton <marshbar...(a)wowway.com> wrote:
> >> shm135 wrote:
> >> >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.
>
> >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.
 |  Next  |  Last
Pages: 1 2
Prev: Unbound Calculation populates from 3 seperate fields
Next: Deleting page headers on pages w/o records