Customize a multiple-column report

1. Open a multiple-column report that has at least one group level in Design view.
2. Click Page Setup on the File menu.
3. Click the Columns tab. Under Grid Settings, make sure Number of Columns is set to a value greater than 1.
4. Under Column Layout, do one of the following:

   To start each group in a new column, click Down, Then Across.

   To start each group in a new row, click Across, Then Down.

5. Click OK.
6. Double-click the section selector for the group header or footer to display its property sheet.
7. Set the NewRowOrCol property to one of the following settings:

   None    (Default) The row or column breaks are determined by the setting in the Page Setup dialog box and by the available space on the page.

   Before Section    Microsoft Access starts printing the current section (the section for which you're setting the property, such as the group header) in a new row or column. It starts printing the next section, for example, the detail section, in the same row or column.

   After Section    Microsoft Access starts printing the current section, such as the group header, in the current row or column. It starts printing the next section, such as the detail section, in the next row or column.

   Before & After    Microsoft Access starts printing the current section, such as the group header, in a new row or column. It starts printing the next section, such as the detail section, in the next row or column.

Note   The Products by Category report in the Northwind sample database starts each group in a new column. To view this report, open the Northwind database in the Samples subfolder of your Office folder, and then open the Products by Category report in Design view.

1. Open a multiple-column report that has at least one group level in Design view.
2. Click Sorting And Grouping on the toolbar to display the Sorting And Grouping box.
3. Click the field or expression for the group level that you want to keep together.
4. In the group properties section of the Sorting And Grouping box, set the KeepTogether property to one of the following settings:

   Whole Group. The group header, all detail records, and the group footer are printed in the same column.

   With First Detail. The group header is printed in a column only if it can also print the first detail record.

5. Double-click the report selector.
6. Set the GrpKeepTogether property to Per Column/Row.

1. Open the report in Design view.
2. Double-click the section selector of the group header to display the property sheet.
3. Set the RepeatSection property to Yes.

1. Open the report in Design view.
2. Double-click the section selector to open the property sheet.
3. Set the KeepTogether property to Yes.