I need a conditional format on a report, depending on the type of quote I want to show or not show some fields. I've programmed a tempVar to achieve this. If I test the value it works fine, but when I run the report I get an error: Can't find the methode or member, what's going wrong here?
Solved it by using the test condition
Code:
Private Sub Details_Format(Cancel As Integer, FormatCount As Integer)
Dim test As Variant
test = TempVars!tempQuoteType
test = (TempVars!tempQuoteType > 2)
Me.rptTotalCosts.Visible = (TempVars!tempQuoteType > 2)
'Me.rptOverhead.Visible = (TempVars!tempQuoteType > 1)
'Me.rptEquipment.Visible = ((TempVars!tempQuoteType = 1) Or (TempVars!tempQuoteType > 2))
End Sub
Last edited:
