• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

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.

1 Solution
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
        Me.Title.visable = True
        Me.Something.Visible = True
    End If

Open in new window

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.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now