Hide a section or control

1. Open a form in Design view, a report in Design view, or a data access page in Design view.
   
   
2. Do one of the following:
   • To open the property sheet for the section that you want to hide in a form or report, double-click the section selector.
     
     
   • To open the property sheet for the section that you want to hide in a data access page, double-click the section bar.
     
     
   • To open the property sheet for the control that you want to hide, make sure the control is selected, and then click Properties on the toolbar.
3. On forms and reports, in the Visible property box, click No. On data access pages, in the Visibility property box, click Hidden.

Notes

• On forms and reports, to hide or unhide a control in response to an event, you can use a macro or event procedure to set the Visible property. Attach the macro or event procedure to the OnCurrent property of a form or the OnFormat property of a report. 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.
  
  
• For form sections, the Visible property has no effect on a column in Datasheet view. To specify whether a column is visible in Datasheet view, use the ColumnHidden property.
  
  
• To hide an object on a form only when you are printing, use the DisplayWhen property.