Microsoft access report caption

Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? In this article. Get caption of closed report Ask Question.

Asked 10 years, 2 months ago. Active 10 years, 2 months ago. Viewed times. Which works docmd. Caption docmd. Improve this question. Icode4food Icode4food 8, 15 15 gold badges 55 55 silver badges 90 90 bronze badges. Add a comment. Active Oldest Votes. You have a couple of options. Already a Member? Join your peers on the Internet's largest technical computer professional community.

It's easy to join and it's free. Register now while it's still free! Already a member? Close this window and log in.

Join Us Close. Join Tek-Tips Forums! Tabular layout A tabular layout is similar to a spreadsheet. Labels are across the top, and the data is aligned in columns below the labels.

Tabular refers to the table-like appearance of the data. This is the type of report that Access creates when you click Report in the Reports group of the Create tab. The tabular layout is a good one to use if your report has a relatively small number of fields that you want to display in a simple list format.

The following illustration shows an employee report that was created by using a tabular layout. Stacked layout A stacked layout resembles a form that you fill out when you open a bank account or make a purchase from an online retailer. Each piece of data is labeled, and the fields are stacked on top of each other.

This layout is good for reports that contain too many fields to display in a tabular format — that is, the width of the columns would exceed the width of the report. The following illustration shows an employee report that was created by using a stacked layout.

Note: In the Report Wizard, this layout is referred to as a columnar layout. Mixed layout You can mix elements of tabular and stacked layouts. For example, for each record, you can arrange some of the fields in a horizontal row at the top of the Detail section and arrange other fields from the same record in one or more stacked layouts beneath the top row.

The following illustration shows an employee report that was created by using a mixed layout. In this example, gridlines are used to provide a visual separation of fields for each employee. Justified layout If you use the Report Wizard to create your report, you can choose to use a justified layout. This layout uses the full width of the page to display the records as compactly as possible.

Of course, you can achieve the same results without using the Report Wizard, but it can be a painstaking process to align the fields exactly. The following illustration shows an employee report that was created by using the Report Wizard's justified layout.

The justified layout is a good layout to use if you are displaying a large number of fields on the report. In the preceding example, if you use a tabular layout to display the same data, the fields extend off the edge of the page.

If you use a stacked layout, each record takes up much more vertical space, which wastes paper and makes the report more difficult to read. Control layouts are guides that you can add to a report while it is open in Layout view or Design view. Access adds control layouts automatically when you use the Report Wizard to build a report, or when you create a report by clicking Report in the Reports group of the Create tab.

A control layout is like a table, each cell of which can contain a label, a text box, or any other type of control. The following illustration shows a tabular control layout on a report.

The orange lines indicate the rows and columns of the control layout, and they are visible only when the report is open in Layout view or Design view. Control layouts help you achieve a uniform alignment of data in rows and columns, and they make it easier to add, resize, or remove fields. By using the tools in the Table and Position groups on the Arrange tab available in Layout view or Design view , you can change one type of control layout to another, and you can remove controls from layouts so that you can position the controls wherever you want on the report.

As mentioned earlier in this article, headers and footers are report sections that you can use to display information that is common to the entire report, or to each page of a report. For example, you can add a Page Footer section to display a page number at the bottom of each page, or you can add a Report Header section to display a title for the entire report. In the Navigation Pane, right-click the report that you want to change, and then click Design View on the shortcut menu.

Verify which sections are already on the report. The sections are separated by shaded horizontal bars called section selectors. The label on each section selector indicates what the section directly below it is. In addition, if there are grouping levels in the report, you might see group headers or footers such as the File As Header shown in the preceding illustration.

By default, group headers and footers are named by using the field name or expression that is the basis of the group. In this case, the name of the grouping field is "File As. Caution: If the section is already present on the report, Access warns you that it will delete the existing section and the controls it contains.