access 2007 - how to show page footer of report on 1st page only?

[JohnLink]

Hi all - having a problem with an old application I did few years ago. User now wants his logo at bottom of page 1 only. But still wants to have page numbering on all pages. Have been tinkering around with the PageFooterSection_Format code as below that I found on these forums ...

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
Cancel = Page > 1
End Sub

This works to hide the logo after page 1 but also hides the page numbering after page 1.
Am just a novice with access code so sorry if too simple??

 

[dhookom]

Have you considered making the logo invisible in pages 2 and beyond?

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
    Me.LogoControlName.Visible = (Page = 1)
End Sub

Duane
Hook'D on Access
MS Access MVP

 

[JohnLink]

Thanks for that suggestion Duane. On my PC I only have Access 2013 so have not been able to test as yet till I go to the users site with Access 2007. One question - will the visible switch set to NOT in that code ie pages 2 and following free up the page space at the bottom. The logo images (x4) take up about 5cm at the bottom of the page and the earlier solution code I was using just made them not visible but still kept the space tied up so the report body text could not flow the full depth of the following pages - just white space was showing which the user did not want. Thanks for your help much appreciated.

One further question how popular is Access nowadays as a client solution? Given it was a bit flaky in the past and with the increase in functionality of cloud business software is it still a force and should I be putting time into up skilling in Access in todays market?

 

[dhookom]

The solution I suggested will not free up any space at the bottom.

You might want to start a new thread regarding MS Access and the future. It's still the very best solution for creating database front-ends.

Duane
Hook'D on Access
MS Access MVP