By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Group Header Title in Access Reports

P: 48
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.
Oct 22 '08 #1
Share this Question
Share on Google+
2 Replies


GazMathias
Expert 100+
P: 189
By Title, I assume you are talking about the label that Access puts there by default. Delete it, If your "TypeOfReporting" field holds the value you want displayed, then you simply place that field into the header.

Click the Field List button, find the "TypeOfReporting" 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.
Oct 22 '08 #2

NeoPa
Expert Mod 15k+
P: 31,186
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!
Oct 22 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.