Set label caption based on text box value in Report !

[siamandm]

hello

how to set a caption of a label based on the value of a text box in a report ?

regards

[HansV]

Let's say that the label is in the Detail section of the report.
Create an On Format event procedure for this section:

Code: Select all

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.ThisLabel.Caption = Me.ThatTextBox
End Sub

where ThisLabel and ThatTextBox are the names of the label and text box, respectively.

Remark: the code will work when you display the report in Print Preview or print it. It won't work if you display the report in Layout View or in Report View.

[siamandm]

Thanks a lot ... working very well

Regards