How to get file report name on Access Report

[Guest]

hi
I want to get the Access Report Name printed on Access Report footer. How do
I get this done? I also tried "=CurrentProject.Name" this only gives the
database name but I'm after the specif report name.
cheers!
Yasas

 

[Tom Lake]

hi
I want to get the Access Report Name printed on Access Report footer. How
do
I get this done? I also tried "=CurrentProject.Name" this only gives the
database name but I'm after the specif report name.
cheers!

Do the report names change often? If not, why not hard code the name right
in the report?

Tom Lake

 

[fredg]

hi
I want to get the Access Report Name printed on Access Report footer. How do
I get this done? I also tried "=CurrentProject.Name" this only gives the
database name but I'm after the specif report name.
cheers!
Yasas

As the control source of an unbound control:
= [Name]

 

[david epsom dot com dot au]

In all previous versions of Access, use
=Report.Name

In Access 2003, create in VBA a public function in the
report, and use that:

=MyReportName()

Function MyReportName
MyReportName = Me.Name
Endif

Air code,
(david)