Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Posts
    9

    Unanswered: Print report name on report

    Hi there everyone,
    Is there a simple way to print the name of a report on the report when it prints. Reason being, I create a lot of access reports as requested by my management staff. sometimes they come back weeks later to request an adjustment to the report. At times it is hard to remember the report name from which the report was printed. Is there anything in access similar to Word and Excel where you can insert the file name as a footer. Thanks for any help.

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    I think (off the top of me head) you can put a textbox on the report and set it equal to

    =me.report.name

    can try that at least.
    Me.Geek = True

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    "Me" is invalid outside VBA. I think this will work:

    =[Name]
    Paul

  4. #4
    Join Date
    Jul 2007
    Posts
    9
    Thanks pbaldy =[name] worked fine. Thank you also nckdryr for the reply.
    Much appreciated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •