MS Access 2010 Different "On Page" vba commands for first and subsequent pages
Posted on 2010-08-28
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.