How to get file report name on Access Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Yasas de Silva said:
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!
Click to expand...

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

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!
Yasas
Click to expand...


As the control source of an unbound control:
= [Name]
 
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)
 
Back
Top