Software

Track down problems more easily by including properties in Access report footers

If your Access report printouts have only a title on them, you'll have a tough time troubleshooting data problems. Save yourself some headaches by including the report filename and record source in the footer.

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

    report footer properties

    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

    printed access footer


    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.

    Editor's Picks

    Free Newsletters, In your Inbox