Displaying the Report's Name function

  • Thread starter Thread starter DEM-L3
  • Start date Start date
D

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.
 
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
 
Why not just set a text box control source to:
=[Name]
Will this display an error if there are no records in the report?
 
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,
 
This worked great! Thanks.

Duane Hookom said:
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


John Spencer said:
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
Click to expand...
Click to expand...
 
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
'====================================================
 
Back
Top