Adding a Reports name to a Report

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

Hi, How do I add a Reports name to the report itself, eg
in the Footer, so that it can be identified easily in the
printout? This seems an easy one but I cannot see anything
in Help. Cheers, Noel
 
Method one:
Add a label to the footer and set its caption by typing in the report name.
Not very high tech, but the report's name won't usually change unless you rename
it.

Method two:
Add a label to the footer, set the caption as " "
In the Open Event of the report use code to set the caption of the label
Me.NameOfLabel.Caption = Me.Name
 
Noel

For Forms, you could use [Name], and I believe it works in reports, too.
Think of it like you would if you were adding page numbering, using
something like

= "Page " & [Page] & " of " [Pages]

in the control source for your page numbering.

Good luck

Jeff Boyce
<Access MVP>
 
Text box with control source of:
=[Name]
That is why it is poor practice to name a field "name". You can do this with
[Width] and [Height] which are report or section properties.
 
Back
Top