Group Header Title in Access Reports

[zandiT]

hello everyone

when working with access reports using the grouping sections, how do you change the title of the group header section depending on which group is being displayed. i have a report that groups depending on a field called TypeOfReporting . It can either be Complete or Edit. i used the sorting and grouping functionality and it groups all the records depending on if the TypeOfReporting was Complete or Edit. but i want to display the title of the groping result and im failing to do so. In other words when the records are grouped according to a TypeOfRecord which is Complete,i want to put a label Complete and when the groping for the Edit records appears i want to put the label Edit to make it clear for the users.
i tried to put a text called txtTitle in the group header section with the following code

if TypeOfReporting = "Complete" Then
txtTitle = "Complete"
else txtTitle = "Edit"
endif

it didnt work but basically that want im trying to do. i hope this makes sense
thankyou in advance i really appreciate it.

[GazMathias]

By Title, I assume you are talking about the label that Access puts there by default. Delete it, If your "TypeOfReportin g" field holds the value you want displayed, then you simply place that field into the header.

Click the Field List button, find the "TypeOfReportin g" entry and drag it into the header or alternately create a new TextBox and set its control source to the field you want, by clicking the drop down arrow and finding it in the list.

[NeoPa]

Check out the GroupLevel item in Reports. It presents in VBA as an array and the elements represent the various groups in your report.

Welcome to Bytes!