Make Access Report Column Visible/Invisible based on Condition

Question

Wondering if there's a way to make an access report column visible or invisible based on a condition? Thanks

Answer 1

In the OnFormat event of your report section (like the Detail section) put code similar to the following:

    If Me.CustomerName = "ABC" Then

        Me.FieldtoHideName.Visible = False

    Else

        Me.FieldtoHideName.Visible = True

    End If

Hope this helps.

Answer 2

You can use Conditional Formatting; select the textbox in report design view, and choose Format... Conditional Formatting from the menu. There's no explicit visible/invisible option but you can set its forecolor to white if the condition is met.

---

John W. Vinson/MVP

Answer 3

You can make a text box invisible pretty easily.  What gets messy is when you want other text boxes to the right to move over so there is no gap in the middle of the columns.  The details depend on the condition and other details in the report's design.