ACC2000: Main Form/Subform Printed as Subdatasheets Printed Incorrectly (223240)


The information in this article applies to:

  • Microsoft Access 2000
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.
  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.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbpending kbprint KB223240
©2004 Microsoft Corporation. All rights reserved.