Report Label

[brandonze]

Is there anyway without going into the design view that I can change a label? I would like to give the user the ability to change the date on the report via a text box on a form.



Thanks

[ketbdnetbp]

You could set the .Caption property of the label in the OnOpen Event of the report, if the form is still open. Try -

Private Sub Report_Open(Cancel As Integer)
Reports!ReportName!LabelName.Caption = [Forms]![YourFormName]![textboxName]

End Sub

Hope this helps,

Jim