Group Header Title Change depending on group displayed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zandiT
    New Member
    • Sep 2008
    • 48

    Group Header Title Change depending on group displayed

    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.
  • overcomer
    New Member
    • Nov 2008
    • 25

    #2
    please see if you have just forgot to specify the property of the text you are trying to setup:

    to change the caption textbox.caption = "new value"
    to change the value textbox.value = "new value"

    Comment

    Working...