When a printed report contains questionable data, your first instinct may be to question the record source. However, when you ask for the report’s name and database table, users will often give you the report title from the printout, which is entirely different from the actual name of the report file. Rather than guess the actual report filename and record source, have Access add this information to the report footer when the report is printed. Follow these steps:

  1. Open the report in Design view.
  2. Click the Text Box control tool and then click and drag in the Report Footer section of the report.
  3. Select the text in the Label control, type Report Name:, and format it as desired.
  4. Click in the text box and enter the following formula:
  5. =[Name]
  6. Click the Text Box control tool and then click and drag in the Report Footer section of the report.
  7. Select the text in the Label control, type Record Source,: and format it as desired.
  8. Click in the text box and enter the following formula:
  9. =[Record Source]

    Figure A shows how the report footer will look.

    Figure A

    When you run the report, Access will output the correct name of the report file and its record source from the properties box in the Report footer, as shown in Figure B.

    Figure B



    Miss an Access tip?

    Check out the Microsoft Access archive and catch up on other Access tips.

    Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.