I want to print the Report saved as name

  • Thread starter Thread starter RBB
  • Start date Start date
R

RBB

I have a large database with many Reports. When I print a
report, as a footer, I would like to print the Reports
saved as name; and if possible the query it is based on. I
can cut and paste the name, but I would like it to
automatically changed it I change the reports saved as
name.
 
Add an unbound text control to the report footer.

Code the Report Footer Format event:
[ControlName] = Me.[Name] & " " & Me.RecordSource
 
Fredg said:
Add an unbound text control to the report footer.

Code the Report Footer Format event:
[ControlName] = Me.[Name] & " " & Me.RecordSource
Click to expand...

Or, if you feel uncomfortable with VBA, you can simply set the text control's
"Control Source" property to (watch line wrap - it's all on one line):

="Report: " & [Report].Name & ", Query: " & [Report].RecordSource
 
Bruce and Fredg

Thank you both for the help, it works great.
RBB
-----Original Message-----

Add an unbound text control to the report footer.

Code the Report Footer Format event:
[ControlName] = Me.[Name] & " " & Me.RecordSource
Click to expand...

Or, if you feel uncomfortable with VBA, you can simply set the text control's
"Control Source" property to (watch line wrap - it's all
Click to expand...
="Report: " & [Report].Name & ", Query: " & [Report].RecordSource

--
Bruce M. Thompson, Microsoft Access MVP
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)within the newsgroups so that all might benefit.<<


.
Click to expand...
 
Back
Top