Embedding a Field in Report Title Bar 1

[readkab]

I have created a Report, and I want one of the fields on the report to be included in the Report Title Bar.

I have tried to use the caption box, but that seems to be a simple text only option.

Basically I am looking to print this report to a PDF printer which uses the Report Bar Title as the file name, so therefore no user interaction is required.

The database is running on Access 2000.

Any help would be appreciated.

 

[NorthNone]

Assuming for the sake of argument that the field you want to use is in the Detail section of your report, put

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.Report.Caption = Me.txtTransData
End Sub

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[readkab]

Thanks for the info.

 

[NorthNone]

Glad I could help. Have a great day.

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.