ObjectFrame.IsVisible Property (Access)
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

ObjectFrame.IsVisible Property (Access)

You can use the IsVisible property in to determine whether a control on a report is visible. Read/write Boolean.

expression .IsVisible

expression A variable that represents an ObjectFrame object.

Note Note

You can set the IsVisible property only in the Print event of a report section that contains the control.

You can use the IsVisible property together with the HideDuplicates property to determine when a control on a report is visible and show or hide other controls as a result. For example, you could hide a line control when a text box control is hidden because it contains duplicate values.

The following example uses the IsVisible property of a text box to control the display of a line control on a report. T

Paste the following code into the Declarations section of the report module, and then view the report to see the line formatting controlled by the IsVisible property:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) 
 If Me!CategoryID.IsVisible Then 
 Me!Line0.Visible = True 
 Me!Line0.Visible = False 
 End If 
End Sub
© 2015 Microsoft