Visible Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

You can use the Visible property to show or hide a form, report, form or report section, data access page, or control. This may be useful if you want to maintain access to information on a form without it being visible. For example, you could use the value of a control on a hidden form as the criteria for a query.

Setting

The Visible property uses the following settings.

You can set this property by using the object's property sheet (for sections and all controls except page breaks), a macro, or .

For forms, reports, and data access pages, you must set this property by using a macro or Visual Basic.

For controls, you can set the default for this property by using the default control style or the method in Visual Basic.

Remarks

The Visible property has no effect on a column in Datasheet view. To specify whether a column is visible in Datasheet view, you use the ColumnHidden property.

To hide an object when printing, you use the DisplayWhen property.

You can use the Visible property to hide a control on a form or report by including the property in a macro or event procedure that runs when the event occurs. For example, you can show or hide a congratulatory message next to a salesperson's monthly sales total in a sales report, depending on the sales total.

Note   There is also a Visible property of the Application object that can be set to cause the application to be invisible. This property can only be set by using Visual Basic.