Access hide/skip report page on condition

Hi experts,

how would you skip or hide a page based on a value on a control on the page? lets say I have a control Accbalance and if it's a negative value skip that page from printing.

Thanks
1desman1Asked:
Who is Participating?
 
slamhoundConnect With a Mentor Commented:
You could use the OnPage event of the report and set the visible property of everything on the report to False.


    If Accbalance < 0 Then
        Me.Title.visable = False
        Me.Something.Visible = False
    Else
        Me.Title.visable = True
        Me.Something.Visible = True
    End If

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.