Displaying the Report's Name function

[DEM-L3]

Hello,
I'm trying to add the report's name in the footer of my report. So far,
I've discovered how to add the db name and the path, but not simply the
report name. I am currently adding a label and typing the name, but as we are
developing the report menu, the names keeping changing. :0) So I'm trying to
automate a few steps.

 

[John Spencer]

Try using
Me.Name
which should return the name of the report.
Or Me.Caption

Then you can use code to assign that to an unbound control in the sections on
format event.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[Duane Hookom]

Why not just set a text box control source to:
=[Name]
Will this display an error if there are no records in the report?

 

[DEM-L3]

Hi John,
Where do I place the Me.Name or Me.Caption? I've tried adding it to the
body of the report and I receive an error.
Thanks,

 

[DEM-L3]

This worked great! Thanks.

Why not just set a text box control source to:
=[Name]
Will this display an error if there are no records in the report?

--
Duane Hookom
Microsoft Access MVP

Try using
Me.Name
which should return the name of the report.
Or Me.Caption

Then you can use code to assign that to an unbound control in the sections on
format event.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[John Spencer]

In VBA code for the section that contains the unbound control

Me.SomeControl = Me.Name



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================