Add or remove a form or report section
Form headers and footers appear at the top and bottom of a form in Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.) and at the beginning and end of a printed form. Report headers (report header: A report section that is used to place information (such as a title, date, or report introduction) at the beginning of a report.) and footers (report footer: A report section that is used to place information that normally appears at the bottom of the page, such as page numbers, dates, and sums.) appear at the beginning and end of a printed report. Page headers (page header: Used to display a title, column headings, dates, or page numbers at the top of every page in a form or report. In a form, the page header appears only when you print the form.) and footers (page footer: Used to display page summaries, dates, or page numbers at the bottom of every page in a form or report. In a form, the page footer appears only when you print the form.) appear at the top and bottom of each printed page — they don't appear in Form view.
- Open a form or report in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
- Do one or more of the following:
- Click Sorting and Grouping on the toolbar.
- In the Sorting and Grouping dialog box, click a row in the Field/Expression column.
- To hide the group header section, in the lower portion of the dialog box, set the Group Header property to No.
- To hide the group footer section, set the Group Footer property to No.
- If you remove a header and footer, Microsoft Access deletes the controls (control: A graphical user interface object, such as a text box, check box, scroll bar, or command button, that lets users control the program. You use controls to display data or choices, perform an action, or make the user interface easier to read.) in the header and footer.
- You can add a header and footer (except group header and footer) only as a pair. If you don't want both a header and a footer, you can set the Visible property of the section you don't want to No, or remove all controls from the section, and then size the section to zero height or set its Height property to 0. You can also set the DisplayWhen property of a form header and footer to specify when you want the header and footer to be displayed - always, in print only, or on the screen only.
Add or remove a data access page section
You can add or remove sections (section: A part of a form, report, or data access page such as a header, footer, or detail section.) at the group level (group level: The depth at which a group in a report or data access page is nested inside other groups. Groups are nested when a set of records is grouped by more than one field, expression, or group record source.) on a data access page that is bound to data. You can add an unbound section to a page that is not bound to any data.
- Open a data access page in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
- Do one or both of the following:
Add or remove a group header, footer, caption, or record navigation section
Add or remove an unbound section
- Open the data access page in Design view.
- Do one of the following: