GroupLevel Members (Access)
.png "GitHub-Mark-64px") |
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
You can use the GroupLevel property in Visual Basic to refer to the group level you are grouping or sorting on in a report.
Properties
Name |
Description |
|---|---|
You can use the Application property to access the active Microsoft Access Application object and its related properties. Read-only Application object. |
|
You can use the ControlSource property to specify what data appears in a control. You can display and edit data bound to a field in a table, query, or SQL statement. You can also display the result of an expression. Read/write String. |
|
You can use the GroupFooter property to create a group footer for a selected field or expression in a report. Read/write Boolean. |
|
You can use the GroupHeader property to create a group header for a selected field or expression in a report. Read/write Boolean. |
|
You can use the GroupInterval property with the GroupOn property to specify how records are grouped in a report. Read/write Long. |
|
You can use the GroupOn property in a report to specify how to group data in a field or expression by data type. For example, this property lets you group a Date field by month. Read/write Integer. |
|
You can use the KeepTogether property for a group in a report to keep parts of a group ? including the group header, detail section, and group footer ? together on the same page. For example, you might want a group header to always be printed on the same page with the first detail section. Read/write Byte. |
|
Returns the parent object for the specified object. Read-only. |
|
Returns a reference to a control's Properties collection object. Read-only. |
|
You use the SortOrder property to specify the sort order for fields and expressions in a report. For example, if you're printing a list of suppliers, you can sort the records alphabetically by company name. Read/write Boolean. |