Hi, I am trying to make a report that has certain fields visible or not depending on if another field is checked "Yes/NO". I currently have this as my code: [Code]Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.[Invoices Extended].[Percent Split] = True Then
Me.PrSplitAmount_2.Visible = True
Me.PrSplitAmount_3.Visible = True
Me.Invoice_Total.Visible = True
Else
Me.PrSplitAmount_2.Visible = False
Me.PrSplitAmount_3.Visible = False
Me.Invoice_Total.Visible = False
End if
End Sub
[code]
and nothing is happening. The fields that should not be showing are still visible. Any help of insight would be amazing! Thank you!