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 » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report-Change Data So That It Doesn't Flow From Bottom Of Page To



 
 
Thread Tools Display Modes
  #1  
Old October 29th, 2008, 02:06 PM posted to microsoft.public.access
Paperback Writer
external usenet poster
 
Posts: 71
Default Report-Change Data So That It Doesn't Flow From Bottom Of Page To

I have a report that has details of accounts (about 60). The problem I'm
having is that at the bottom of the page it will list half the account data,
and then show the rest at the top of the following page. I've tried to force
a new page before, after, and before & after the section, but I'm not having
luck. This basically makes each page have account information for just that
one account.

I need the report to know that all the data for one account will not fit at
the bottom of the page, and to show it entirely on the following page.
  #2  
Old October 29th, 2008, 02:27 PM posted to microsoft.public.access
Stefan Hoffmann
external usenet poster
 
Posts: 991
Default Report-Change Data So That It Doesn't Flow From Bottom Of PageTo

hi,

Paperback Writer wrote:
I've tried to force
a new page before, after, and before & after the section, but I'm not having
luck. This basically makes each page have account information for just that
one account.

What sections? Have you tried the KeepTogether property?


mfG
-- stefan --
  #3  
Old October 29th, 2008, 02:45 PM posted to microsoft.public.access
Paperback Writer
external usenet poster
 
Posts: 71
Default Report-Change Data So That It Doesn't Flow From Bottom Of Page

The "Keep Together" is set to yes, which I think is the default.

I've basically tried this on all the sections within the report. I've done
a lot of experimenting, but to no avail.


"Stefan Hoffmann" wrote:

hi,

Paperback Writer wrote:
I've tried to force
a new page before, after, and before & after the section, but I'm not having
luck. This basically makes each page have account information for just that
one account.

What sections? Have you tried the KeepTogether property?


mfG
-- stefan --

  #4  
Old October 29th, 2008, 03:12 PM posted to microsoft.public.access
Stefan Hoffmann
external usenet poster
 
Posts: 991
Default Report-Change Data So That It Doesn't Flow From Bottom Of Page

hi,

Paperback Writer wrote:
The "Keep Together" is set to yes, which I think is the default.
I've basically tried this on all the sections within the report. I've done
a lot of experimenting, but to no avail.

I think, you need an additional group for your account.


mfG
-- stefan --
  #5  
Old October 29th, 2008, 04:11 PM posted to microsoft.public.access
Paperback Writer
external usenet poster
 
Posts: 71
Default Report-Change Data So That It Doesn't Flow From Bottom Of Page

Can you explain?


"Stefan Hoffmann" wrote:

hi,

Paperback Writer wrote:
The "Keep Together" is set to yes, which I think is the default.
I've basically tried this on all the sections within the report. I've done
a lot of experimenting, but to no avail.

I think, you need an additional group for your account.


mfG
-- stefan --

  #6  
Old October 29th, 2008, 04:37 PM posted to microsoft.public.access
Stefan Hoffmann
external usenet poster
 
Posts: 991
Default Report-Change Data So That It Doesn't Flow From Bottom Of Page

hi,

Paperback Writer wrote:
Can you explain?

You can only keep sections - you've tried already the default ones
together or groups. So when you create a report grouped by account, then
you can set the KeepTogether property for this group. In the group
header you may place your account information and in the detail section
the account entries.


mfG
-- stefan --
 




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 06:50 AM.


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