A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Memo in Report causing blank pages/other issues



 
 
Thread Tools Display Modes
  #1  
Old May 26th, 2010, 07:58 PM posted to microsoft.public.access.reports
shm135
external usenet poster
 
Posts: 26
Default Memo in Report causing blank pages/other issues

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?
  #2  
Old May 26th, 2010, 11:21 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Memo in Report causing blank pages/other issues

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]
  #3  
Old May 27th, 2010, 06:07 AM posted to microsoft.public.access.reports
shm135
external usenet poster
 
Posts: 26
Default Memo in Report causing blank pages/other issues

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.

--
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!
  #4  
Old May 27th, 2010, 01:58 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Memo in Report causing blank pages/other issues

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
procedu
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]
  #5  
Old May 28th, 2010, 06:19 PM posted to microsoft.public.access.reports
shm135
external usenet poster
 
Posts: 26
Default Memo in Report causing blank pages/other issues

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
procedu
* * * * 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.
  #6  
Old May 28th, 2010, 08:09 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Memo in Report causing blank pages/other issues

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
procedu
* * * * 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]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.