Monday, November 1, 2010

Access 2007: Print Access report summaries without redesigning the report

Your supervisor or director would like a printout of the summary data in all of the reports in your database for her end-of-fiscal year department report. You need to print out all 10 reports without the detail data, and you need to have it ready within the hour. Fortunately, you don't need to create new reports -- you can hide the detail section so the detailed data does not appear in the printout. Here's how...
  1. In the Database window, click Reports under Objects.
  2. Click the name of the report, and then click the Design button.
  3. Right-click within a blank area of the Detail section.
  4. Select Properties.
  5. Under the Format tab, click in the Visible property box and select No.
When you print the reports, all sections but the detail sections will print. You can use the Visible property to hide any section of the report.

1 comment:

  1. Hi, Great blog!
    I invite you to join the Babel Project II, just a way of keeping in touch.
    Cheers from Argentina.