Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3889
  • Last Modified:

How to get Report Header on every page of Access report

In DesignView, report properties shows me Name, Force New Page, etc... How I can make my title appear on every page of the Report?   "All Pages"?  but where do I type that in?
0
bergen69
Asked:
bergen69
  • 4
  • 3
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
 Use the page header, not the report header.

JimD.
0
 
bergen69Author Commented:
where in Page Header?  In grey area  under Page header, under All tab, I entered 'All Pages" for Page Header and Page Footer, but print preview doesn't show my title on each page...
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<where in Page Header?  In grey area  under Page header, under All tab, I entered 'All Pages" for Page Header and Page Footer, but print preview doesn't show my title on each page...>>

  By definition, the page header/footer is supposed to appear on every page.  Report Header/Footer appear only at the start and end of the report.

  Check the page header band by right clicking on it when in design view and select properties.  Make sure its visible property is True.  Then make sure the band is expanded enough to display the controls.

  You should now be able to see.

JimD
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
Jeffrey CoachmanCommented:
bergen69,

In other words...
Close the property box.
You do not need it for this.

All you need to do is open the report in design view, and move the info from the Report header to the Page Header.

That's it.

Please assign the points to JDettman
screenshot02.JPG
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
boag2000,

  Sometimes a picture is worth a thousand words.  

  Keep the points.

JimD
0
 
Jeffrey CoachmanCommented:
bergen69,

Didn't I say:
<Please assign the points to JDettman> ?
;-)

While my post may have helped, it was actually JDettman post that "solved" the issue.
Pleas contact the support staff (http://www.experts-exchange.com/support.jsp) and have the "accepted" solution changed from my post to JDettman's

JeffCoachman
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Jeff,

  The extra time you took to capture and post a picture may have made your comment a better one as far as bergen was concerned.

  I'm fine with where the points stand.

  I'm just glad the problem is solved.

JimD.
0
 
Jeffrey CoachmanCommented:
OK, but I always make the offer to re-assign the points.
Fair is fair
;-)

Jeff
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now