I have a report which is basically a pic-sheet for Customer Orders. In the detail section you have a QtyOrdered, QtyShipped, and a line to X the product off, followed by a Description.
If the description contains a certain value... let's say "Bananas" for instance, I am trying to get JUST that line to be hidden/invisible.
I have this in the ON LOAD event - but it does nothing
Private Sub Report_Load()
If Me.Description.Value = "Bananas" Then
Me.QtyOrdered.Visible = False And Me.QtyOrdered.Visible = False And Me.Description.Visible = False
Appreciate any help or suggestions