ACC2000: Main Form/Subform Printed as Subdatasheets Printed Incorrectly

• Microsoft Access 2000

SYMPTOMS

When you try to print the main form or subform as a subdatasheet, the subform records overwrite the column headings and the main form records.

CAUSE

The DefaultView property of the subform is set to Single Form or Continuous Form.

RESOLUTION

Change the DefaultView property of the subform to Datasheet View.

MORE INFORMATION

A main form opened in Datasheet view shows the Expand buttons down the left margin of the form representing the subdatasheet. If the user expands all subdatasheet records in order to print the results, the first page will be printed correctly, but the headers of all subsequent pages will be overwritten by the subdatasheet.

Steps To Reproduce Behavior

1. Open the sample database Northwind.mdb.



2. In the Database window, click Forms under Objects.



3. Open the Categories form in Design view.



4. Set the DefaultView property and the ViewsAllowed property to Datasheet.



5. On the View menu, click Datasheet View.



6. On the Format menu, click Subdatasheet, and click Expand All.



7. On the File menu, click Print Preview.
   
   Note that the column headings and main form record at the top of Page 1 preview correctly.



8. Move to Page 2, 3, and so on.
   
   Note that the column headings and main form records are overwritten by the subforms data on all subsequent pages.

REFERENCES

For more information about subdatasheets, click Microsoft Access Help on the Help menu, type "use subdatasheets" in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Additional query words: pra

Keywords : kbprint kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug