Microsoft KB Archive/223240

= ACC2000: Main Form/Subform Printed as Subdatasheets Printed Incorrectly =

Article ID: 223240

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q223240





Novice: Requires knowledge of the user interface on single-user computers.



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.
 * 1) 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.

