Access 2013 Reports: Different Header for First Page

geospatial

Active Member
Joined
Sep 2, 2008
Messages
290
1. Is it possible to have a different page header on the first page without VBA. If not I can work it in with VBA, but the problem would be that I am not sure how you would change where the text would show.

I am using Access 2013
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
no, and the vb is not hard, put 2 headers, 1 visible , 1 not
put this in the ON PRINT event:

lblHeader1.visible = me.page = 1
lblHeader2.visible = me.page > 1
 
Upvote 0
1. Is it possible to have a different page header on the first page without VBA. If not I can work it in with VBA, but the problem would be that I am not sure how you would change where the text would show.

I am using Access 2013

It is it possible do do it without any VBA code. I do it a lot.

This simple Hack uses the Report header and changing one property.

The Report Header only prints on page one by design. Use this to set up what you want on the page one header.

Set up the page header section to be the way you want it for page(s) two and later.

To get it to work you only have to change a single report property!

The HACK: View the Report's Property sheet. On the format tab change the Page Header from "All Pages" to "Not with Rpt Hdr".

report_page_header_property.png
 
Last edited:
Upvote 0

Forum statistics

Threads
1,221,709
Messages
6,161,442
Members
451,705
Latest member
Priti_190

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top