Control label caption based off of group header textbox value

[Stephenson]

Hello all,



I have an unbound label, lblTest that I would like to show the value of a textbox, tboRockProduct that is in a group header named ghRock. If tboRockProduct isnull I would like lblTest not to be visible.

I've tried a few things thus far and been able to get lblTest to not be visible, but have not been able to get it to show the value of tboRockProduct. I've used variations of the following code.

Private Sub Report_Load()  
With ghRock
   If Not IsNull(tboRockProduct) Then
    Me.lblTest.Caption = tboRockProduct
    ElseIf IsNull(tboRockProduct) Then
    Me.lblTest.Visible = True
End If
End With
End Sub

Is this not possible as the report continues and the value of tboRockProduct varies? I'm happy to hear any suggestions you may have to help.

Thank you for looking.

[June7]

Consider a textbox with expression in ControlSource and code in the Detail section Format event. Format event only triggers when printing or PrintPreview.

[Stephenson]

Thank you for the suggestion June7. I will give this a try

[Stephenson]

June7,

Thank you for the help. I used

=IIf(IsNull([tboRockProduct]),"",[VendorName])

As the control source for my textbox and it worked like a charm.

Great idea.