Prev: Unbound Calculation populates from 3 seperate fields
Next: Deleting page headers on pages w/o records
From: Marshall Barton on 28 May 2010 15:09
shm135 wrote:
>On May 27, 8:58�am, Marshall Barton wrote:
>> shm135 wrote:
>> >On May 26, 6:21�pm, Marshall Barton 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.
>>
>
>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.

--
Marsh
MVP [MS Access]
First  |  Prev  | 
Pages: 1 2
Prev: Unbound Calculation populates from 3 seperate fields
Next: Deleting page headers on pages w/o records