Report.NextRecord property (Access)
The NextRecord property specifies whether a section should advance to the next record. Read/write Boolean.
Syntax
expression.NextRecord
expression A variable that represents a Report object.
Remarks
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. |
To set this property, specify an event procedure for a section's OnFormat property.
Microsoft Access sets this property to True before each section's Format event.
Example
The following example sets the NextRecord property to False for a given report.
Public Sub ChangeNextRecord(r As Report)
r.NextRecord = False
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.