[MSAccessProfessionals] Hide Box on report based on value of control

Hello all,

I have a report with a header named GroupHeader3 that has a box in the header named boxVariance.
I am trying to hide this box if a control in the detail section is > 0 or < 0 essentially <> 0. the Name of the control is Computed difference and the Control source is VarianceCalc.

I have tried putting code in practically every event and it will not give me the results that i need.
this is the code that i finally gave up trying to adjust.

 If Me![VarianceCalc] > 0 Then
    Me.GroupHeader3.Visible = True
'Else Me![VarianceCalc] = 0 Then
    Me.GroupHeader3.Visible = False
End If

I tried this as well

'If Me.[VarianceCalc].Value > 0 Then
'    boxVariance.Visible = True
''ElseIf [VarianceCalc].Value < 1 Then
''    boxVariance.Visible = False
' Else
' boxVariance.Visible = False
'End If

thank you

Jim Wagner

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116243) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_