You can use the NewRowOrCol property to specify whether a section and its associated data is printed in a new row or column within a multiple-column report or multiple-column form. For example, you can use this property to print each group header at the top of a new column in a multiple-column report.
Note The NewRowOrCol property doesn't apply to page headers or page footers.
Setting
The NewRowOrCol property uses the following settings.
Setting | Visual Basic | Description |
---|---|---|
None | 0 | (Default) The row or column breaks are determined by the settings in the Page Setup dialog box (available by clicking Page Setup on the File menu) and the available space on the page. |
Before Section | 1 | Microsoft Access starts printing the current section (the section for which you're setting the property, such as a group header section) in a new row or column. It then prints the next section, such as a detail section, in that same row or column. |
After Section | 2 | Microsoft Access starts printing the current section, such as a group header section, in the current row or column. It starts printing the next section, such as a detail section, in the next row or column. |
Before & After | 3 | Microsoft Access starts printing the current section in a new row or column. It starts printing the following section in the next row or column. |
You can set this property by using the section's property sheet, a macro, or Visual Basic.
You can set the NewRowOrCol property only in form Design view or report Design view.
Remarks
The following items are some sample settings for a group header section in a multiple-column report. Make sure Down, Then Across is selected under Column Layout on the Columns tab of the Page Setup dialog box.
Sample setting | Result |
---|---|
Before Section | The group header is printed at the top of a new column. |
After Section | The detail section is printed at the top of a new column. |
Before & After | The group header is printed in a column by itself, and the detail section is printed at the top of a new column. |
Sections in a form or report are normally printed vertically down a page. The default Column Layout option is Across, Then Down. You can print the sections in multiple columns across a page by clicking Down, Then Across under Column Layout on the Columns tab of the Page Setup dialog box.
If you set the NewRowOrCol property to Before Section, the vertical or horizontal orientation of the page affects how the section appears when printed. If you click Across, Then Down under Column Layout on the Columns tab of the Page Setup dialog box, Microsoft Access starts printing the section at the beginning of a new row; if you click Down, Then Across, Microsoft Access starts printing the section at the beginning of a new column.