MoveLayout, NextRecord, PrintSection Properties
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
You can use combinations of these property settings in Visual Basic to specify or change a report's layout when the report is previewed, printed, or saved to a file:
The MoveLayout property specifies whether Microsoft Access should move to the next printing location on the page.
The NextRecord property specifies whether a section should advance to the next record.
The PrintSection property specifies whether a section should be printed.
Setting
The MoveLayout property uses the following settings.
Setting | Description |
---|---|
True (1) | (Default) The section's Left and Top properties are advanced to the next print location. |
False (0) | The section's Left and Top properties are unchanged. |
The NextRecord property uses the following settings.
Setting | Description |
---|---|
True | (Default) The section advances to the next record. |
False | The section doesn't advance to the next record. |
The PrintSection property uses the following settings.
Setting | Description |
---|---|
True | (Default) The section is printed. |
False | The section isn't printed. |
To set these properties, specify a macro or for a section's OnFormat property.
Microsoft Access sets these properties to True before each section's event.
Remarks
These properties are useful when you want to use a report as a template into which you write data from a macro or Visual Basic as you print.
The following table shows the result of different setting combinations for these properties.
MoveLayout | NextRecord | PrintSection | Description |
---|---|---|---|
True | True | True | (Default) Move to the next print location, get the next record, and print the data. |
True | False | True | Move to the next print location, don't advance to the next record, but print the data. This combination is typically used when the data in a section requires more space than the layout allows and you want to print the remaining data in the space that would otherwise be occupied by the next section. |
False | True | False | Skip a record without leaving a blank space on the page. |
True | True | False | Skip a record and leave a blank space on the page. |
True | False | False | Leave a blank space without skipping a record. |
False | True | True | Print the current record on top of the last record as an overlay. |
False | False | True | Not allowed. |
False | False | False | Not allowed. |