Using "IsVisible" on a report

I am trying to set the visible property of a text box (Issuer) based on whether or not another text box (Security_ID) is visible on the report.  I have the following in my control source:

=IIf(Security_ID.IsVisible,[Issuer],Null)

When I run the report, everything shows up #Error.

Thanks for any help
mak345Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
In VBA code...

If Me.Security_ID.Visible = False then
    Me.Issuer.Visible = False
else
    Me.Issuer.Visible = True
End
0
 
Joe OvermanEngineerCommented:
Try this syntax

=IIf(report!Security_ID.Visible = -1,report!Issuer.value,Null)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.