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

Crystal,

Perfect idea.

Thank You 

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io>
Sent: Wednesday, July 27, 2022 4:49 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Hide Box on report based on value of control

 

hi Jim,

a TEXTbox? (if not,make it one) then instead of code ... use Conditional Formatting and Expression Is

kind regards,
crystal

msaccessgurus.com

On 7/27/2022 5:51 PM, Jim Wagner wrote:

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