Change the sort on a Report Grouping w/VBA

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Currently we have a report that changes it's Grouping of the report
programmatically when the report opens using:

Me.GroupLevel(0).ControlSource = "Vendor"

However I would also like to specify the sorting of the Grouping to be
either Ascending or Descending using VBA but I could not find the syntax for
it. Does anyone know of an example or what the property is? Thanks.
 
Scott said:
Currently we have a report that changes it's Grouping of the report
programmatically when the report opens using:

Me.GroupLevel(0).ControlSource = "Vendor"

However I would also like to specify the sorting of the Grouping to be
either Ascending or Descending using VBA but I could not find the syntax for
it. Does anyone know of an example or what the property is? Thanks.
Click to expand...

For Descending sort:
Me.GroupLevel(0).SortOrder = True

and for Ascending:
Me.GroupLevel(0).SortOrder = False
 
ya know I looked at that property but it wasn't obvious what to do. Thanks
Marsh!!!
 
Back
Top