Visibility Macro

[pwicr]

:banghead:I'm trying to get a box to only show if the state of Montana is there.

here is what I have.

 

[boblarson]

Remove both of the

Me.Visible =

parts.

The value for the macro is either going to be -1 or 0

So,

IIf([STATE/PROV]="MT", -1, 0)

 

[pwicr]

Remove both of the

Me.Visible =

parts.

The value for the macro is either going to be -1 or 0

So,

IIf([STATE/PROV]="MT", -1, 0)

Still not working. I have it as a label in my report and I have it set up under report properties "On Open"

I have the label associated with the control "State/Prov"

 

[boblarson]

The On Open event is not the one to use. You would want it in the ON FORMAT event of the section where the controls are. If it is the Detail Section, then the macro should be called in the ON FORMAT event of the Detail Section. And, if you use Report View as well, it would need to be in the ON PAINT event as well.

 

[pwicr]

The On Open event is not the one to use. You would want it in the ON FORMAT event of the section where the controls are. If it is the Detail Section, then the macro should be called in the ON FORMAT event of the Detail Section. And, if you use Report View as well, it would need to be in the ON PAINT event as well.

here's what i have now.

 

[pwicr]

I'm feeling like a giant idiot that I can't get this to work.