Good Day all;
Is it possible to hide fields on a report if they equal zero?
I have a currency field on my report called diff, what I want to do is hide other fields on my report should this field be equal to zero.
This is the code I have for the ‘On Load’ event of my report:
If Me.diff = 0 Then
Me.apd_no.Visible = False
Me.apd_name.Visible = False
Me.period.Visible = False
Me.Label48.Visible = False
Me.duefromfigures.Visible = False
Me.Label49.Visible = False
Me.duty_declared_st.Visible = False
Me.Label51.Visible = False
Me.diff.Visible = False
Me.Line53.Visible = False
End If
But unfortunately it isn’t working, would someone be able to give me a pointer as to where I have gone wrong?
Kind Regards
Tor Fey
Is it possible to hide fields on a report if they equal zero?
I have a currency field on my report called diff, what I want to do is hide other fields on my report should this field be equal to zero.
This is the code I have for the ‘On Load’ event of my report:
If Me.diff = 0 Then
Me.apd_no.Visible = False
Me.apd_name.Visible = False
Me.period.Visible = False
Me.Label48.Visible = False
Me.duefromfigures.Visible = False
Me.Label49.Visible = False
Me.duty_declared_st.Visible = False
Me.Label51.Visible = False
Me.diff.Visible = False
Me.Line53.Visible = False
End If
But unfortunately it isn’t working, would someone be able to give me a pointer as to where I have gone wrong?
Kind Regards
Tor Fey