Using Reports in Access 2000
If you use File/Print to print information from an Access database you have very little control over how the data is printed. A better approach is to design a "Report" that specifies what data is to be printed and where it is to appear on the page.
STEP 1 Setting up a Report is similar to setting up a Form. There are three sections to the Report - the Page Header, the Detail section and the Page Footer. Each section can contain data, text and images. Anything you can include on a Form can be included in each of the sections. The usual approach would be to have most of the data in the "Detail" section.
STEP 2 Go to the report Properties menu by right-clicking on the Form Selection button.
Select Properties from the menu ...
STEP 3 Nominate the source of the data ...
STEP 4 Close the Report properties window and then drag and drop the fields from the Field List box onto the Report as you would when creating a Form.
STEP 5 Click on the print View button to preview the Report ...
Print out the completed Report.
|
NOTE: If you want only one record per page right click the Section Selector and then go to Properties (or double click the Section Selector) as indicated below ... |
Select Properties ...
From the Force New Page drop-down menu select After Section. Each record will be printed on a separate page ...
|
NOTE : If you want to select certain records to be printed you need to use a Query, rather than the whole database. In STEP 3 above you would select "Query1" rather than "sample table1" |