Pages.Remove

Posted by: pelipor on 4 August 2017, 2:43 pm EST

  • Posted 4 August 2017, 2:43 pm EST

    Hello, I need remove the last page of my report. I have try two form, in the ReportEnd event, :

    a) Me.Pages.Remove (Me.Pages.Count)

    b) Dim LastPag As Long
        LastPag=Me.Pages.Count
        Me.Pages.Remove LastPag

    In case (a) the error is: Value of Range and the second case the error is: Bad Parameter Value

    Thanks for all.
    Peli
  • Replied 4 August 2017, 2:43 pm EST

    The pages collection is zero based.

    Me.Pages.Remove Me.Pages.Count - 1
    Me.Pages.Commit
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels