title | keywords | f1_keywords | ms.prod | api_name | ms.assetid | ms.date | ||
---|---|---|---|---|---|---|---|---|
OptionGroup.IsVisible Property (Access) |
vbaac10.chm10860 |
|
access |
|
6652c226-ee95-b94a-dabc-942e0d9d5226 |
06/08/2017 |
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 OptionGroup object.
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
Else
Me!Line0.Visible = False
End If
End Sub