Solved

Using "IsVisible" on a report

Posted on 2008-06-26

Microsoft Access

1 solution

498 Views

Last Modified: 2013-11-28

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

Comment

Question by:mak345

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 66

Accepted Solution

by:Jim Horn

Jim Horn earned 50 total points

ID: 218761532008-06-26

In VBA code...

If Me.Security_ID.Visible = False then
Me.Issuer.Visible = False
else
Me.Issuer.Visible = True
End

LVL 8

Expert Comment

by:Joe Overman

ID: 218764962008-06-26

Try this syntax

=IIf(report!Security_ID.Visible = -1,report!Issuer.value,Null)

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Monitor Privileged Accounts in Active Directory [VIDEO]

Article by: Gene

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…

Splitting Microsoft Access Database with Multiple User

Article by: Jason

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…

Using a Criteria Form with an Access Report

Video by: TechMommy

Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

Access Desktop Databases – A Quick Tour

Video by: Jim

What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.