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
- Open the sample database Northwind.mdb.
- In the Database window, click Forms under Objects.
- Open the Categories form in Design view.
- Set the DefaultView property and the ViewsAllowed property to Datasheet.
- On the View menu, click Datasheet View.
- On the Format menu, click Subdatasheet, and click Expand All.
- On the File menu, click Print Preview.
Note that the column headings and main form record at the top of Page 1 preview correctly.
- 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: kbbug kbprint kbpending KB223240
