Dynamic report name

In access you can set the report name dynamically. Generally we set a report name statically. This tutorial goes to describe how to set a report name dynamically.

1. Open your report and go to report property and create an event of Report header with Format

Report header property

Report header property

2. Write down this code

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
Me.Caption = "Customer ID :" & Customer_id
End Sub

dynamic report

hereĀ  & Customer_id is a field name. It will provide the dynamically customer id. You can set any field name of your report.

You can download a sample database of dynamic report name

Share on :

Leave a Reply

two × 9 =