Adding a Reports name to a Report

[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

 

[John Spencer (MVP)]

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

 

[Jeff Boyce]

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>

 

[Duane Hookom]

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.