• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

MS Access 2010 Different "On Page" vba commands for first and subsequent pages

I have constructed a report that has a Report Header and a Page Header. The Page Header does not appear on the first page - This is the way I want it. Using the Report's "on page" setting, I have used vba code to draw a rectangular box around the detail section of the report's First Page. For the 2nd and subsequent pages, the rectangular box needs different dimensions because the header section for the first and subsequent pages are different dimensions. Within an If-Then Statement within the "on page" setting, can I use certain vba code for the first page - and then different vba code for the 2nd and subsequent pages? How do I identify the first page name or number? How do I define the 2nd and subsequent pages? Thanks in advance.
0
James_Moroney
Asked:
James_Moroney
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
James,
 Yes, you can execute different page logic by checking the page property.  The page property will tell you what page your currently on.
JimD.
0
 
James_MoroneyAuthor Commented:
Thanks.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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