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  

Repeat Section but not all labels



 
 
Thread Tools Display Modes
  #1  
Old November 23rd, 2005, 09:00 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Repeat Section but not all labels

Hello,
I have a report that i would to have a specific header repeated on the
next page but would also like only selected labels/text boxes repeated. The
reason for this is one of these boxes can grow very large and may split
pages. I would not like to repeat this box but have it continue.

Is this possible?

THanks
  #2  
Old November 24th, 2005, 02:47 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Repeat Section but not all labels

Are the labels above the text boxes? If so, the simplest solution would be
to create another group header based on the same field. Put the labels in
this new header, and mark it not to repeat.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ben" ben_1_ AT hotmail DOT com wrote in message
...
Hello,
I have a report that i would to have a specific header repeated on the
next page but would also like only selected labels/text boxes repeated.
The
reason for this is one of these boxes can grow very large and may split
pages. I would not like to repeat this box but have it continue.

Is this possible?

THanks



  #3  
Old November 24th, 2005, 05:06 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Repeat Section but not all labels

unfortunately i would like to keep them on the same 'level' it it were possible

"Allen Browne" wrote:

Are the labels above the text boxes? If so, the simplest solution would be
to create another group header based on the same field. Put the labels in
this new header, and mark it not to repeat.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ben" ben_1_ AT hotmail DOT com wrote in message
...
Hello,
I have a report that i would to have a specific header repeated on the
next page but would also like only selected labels/text boxes repeated.
The
reason for this is one of these boxes can grow very large and may split
pages. I would not like to repeat this box but have it continue.

Is this possible?

THanks




  #4  
Old November 24th, 2005, 06:02 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Repeat Section but not all labels

Hmm: that's not as straight forward.

You cannot use FormatCount, PrintCount, or HasContinued to determine if the
section is printing again because of its RepeatSection property.

You cannot use variables set the report events to track things that span
pages, because the events may not fire for pages that are not actually
printed/previewed.

You cannot just rely on the Top property of the report, because a new group
header could appear at the top of the page.

Perhaps someone else has a suggestion.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ben" ben_1_ AT hotmail DOT com wrote in message
...
unfortunately i would like to keep them on the same 'level' it it were
possible

"Allen Browne" wrote:

Are the labels above the text boxes? If so, the simplest solution would
be
to create another group header based on the same field. Put the labels in
this new header, and mark it not to repeat.

"Ben" ben_1_ AT hotmail DOT com wrote in message
...
Hello,
I have a report that i would to have a specific header repeated on the
next page but would also like only selected labels/text boxes repeated.
The
reason for this is one of these boxes can grow very large and may split
pages. I would not like to repeat this box but have it continue.



 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Making a report that can leave records blank based on user input. Billy Setting Up & Running Reports 3 June 20th, 2005 12:46 PM
Repeat Column Labels on Each Page Karl Burrows Setting Up & Running Reports 2 May 14th, 2005 04:11 PM
How do I repeat labels in a Pivot Table teddy General Discussion 1 April 12th, 2005 08:05 PM
Header & Section breaks JenPrl Page Layout 4 September 17th, 2004 08:55 PM
Problems Printing Mailing Labels... Grim Reaper Setting Up & Running Reports 0 May 19th, 2004 12:31 AM


All times are GMT +1. The time now is 06:07 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.