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  

Print Group headings on top of page



 
 
Thread Tools Display Modes
  #1  
Old March 26th, 2010, 05:05 AM posted to microsoft.public.access.reports
Dennis
external usenet poster
 
Posts: 1,222
Default Print Group headings on top of page

Hi,

I'm running Access via Xp Office Pro on Windows 7.

I have a report that is broken out by group using a block format and was
generated by the print wizzard.

I noticed that the group values (in my case a status description) is only
printed the one time.

If the group crosses over a page, I want to print the current value of the
group value at the top of the next page. Is that possible? And if so, how
do I do it?

Thanks,

Dennis
  #2  
Old March 26th, 2010, 11:57 AM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Print Group headings on top of page

Dennis wrote:
I'm running Access via Xp Office Pro on Windows 7.

I have a report that is broken out by group using a block format and was
generated by the print wizzard.

I noticed that the group values (in my case a status description) is only
printed the one time.

If the group crosses over a page, I want to print the current value of the
group value at the top of the next page. Is that possible? And if so, how
do I do it?



Either add a text box bound to the grouping field to the
Page header or set the group header section's RepeatSection
property to Yes. The page header may not be as versatile
for all situations, but is more straightforward in simple
situations.

--
Marsh
MVP [MS Access]
  #3  
Old March 26th, 2010, 04:42 PM posted to microsoft.public.access.reports
Dennis
external usenet poster
 
Posts: 1,222
Default Print Group headings on top of page

Marshall,

I set the group header section's RepeatSection property to Yes.

This did exactly what I wanted. Thank you for that little pearl of knowledge.


Dennis
 




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 12:13 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.