HELP! Display Filename in Footer

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

Guest

I am trying to get my Access 2002 reports to display the report name on the
footer.

I have tried (1):
=CurrentDb.Name

and also tried (2):
="Report Name: " & Screen.ActiveReport.Name

Option (1) inserted the file path, not the name.
Option (2) inserted the name, BUT only when I already have the file open in
design mode. Opening the report through the Reports Switchboard (or any other
way) causes the report name to read as #Error.

How can I display these reports in my footer when they are printed?
 
I am trying to get my Access 2002 reports to display the report name on the
footer.

I have tried (1):
=CurrentDb.Name

and also tried (2):
="Report Name: " & Screen.ActiveReport.Name

Option (1) inserted the file path, not the name.
Option (2) inserted the name, BUT only when I already have the file open in
design mode. Opening the report through the Reports Switchboard (or any other
way) causes the report name to read as #Error.

How can I display these reports in my footer when they are printed?
Click to expand...

=CurrentDb.Name returns the path and name of the database.
="Report Name: " & [Name] returns the name of the report.
 
Back
Top