none
Access report change label value based on page number RRS feed

  • Question

  • Hi
    I have a label on an Access report,  I want to be able to set the value to A if it is page number 1 and B if it is any other page.

    I have tried the following code on the form load but this fails to work:

    Private Sub Report_Load()
    If Me.Page = 1 Then
         Me.Label01.Caption = "A"
    Else
         Me.Label01.Caption = "B"
    End If
    End Sub

    Please can anyone help?
    Wednesday, May 25, 2016 12:26 PM

Answers

  • Hi system,

    Which view you want to achieve this function? If you want in Print View, you could try these code in Detail_Print.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Thursday, May 26, 2016 3:03 AM