Share via

Make access page header start on second page

Anonymous
2011-03-25T23:02:09+00:00

I need the page header to start on the second page of the report. I also need to show the page number after page 1. How do I make that happen?

Thank you,

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2011-03-26T03:45:14+00:00

For the page header put this in the page header's On Format event:

Me.PageHeaderSection.Visible = ([Page] <> 1)

and for the page numbers

Me.PageFooterSection.Visible = ([Page] <> 1)

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2013-06-20T06:16:02+00:00

    That worked perfectly, just make sure you paste it in the (format) in the header's event.

    Was this answer helpful?

    0 comments No comments