Microsoft KB Archive/117172

= ACC: Detail Section Blank When Form Is Printed or Previewed =

Article ID: 117172

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q117172



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you print or preview a form, the detail section of the form is blank, even though controls are visible in the detail section when you view the form in Form view. Other sections, such as the form header and form footer, appear correctly when you print or preview the form.



CAUSE
This behavior occurs if the form's underlying table or query returns no records, or if the detail section's DisplayWhen property is set to Screen Only.



RESOLUTION
To resolve this behavior, do one of the following:
 * Make sure the underlying table or query returns at least one record.
 * Save the form as a report and print/preview the report.
 * Place necessary controls in other sections, for example, in the form header or in form footer.

If the DisplayWhen property of the detail section is set to Screen Only, change it to Always or Print Only.



Example 1: No Records in Underlying Table

 * 1) Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0)
 * 2) Create a new table with several fields. Do not add any records to the table.
 * 3) Save the new table as Table1, and then close it.
 * 4) Create a new form based on Table1. Place the fields from the table in the form's detail section.
 * 5) Place some controls, such as labels or buttons, in the form header and form footer.
 * 6) View the form in Form view. Note that you can see all the controls.
 * 7) Print or preview the form. Note that the detail section is blank.

Example 2: DisplayWhen Property Set to Screen Only

 * 1) Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0)
 * 2) Preview the Categories form. Note that you can see the controls in the form's detail section.
 * 3) Open the Categories form in Design view.
 * 4) Change the detail section's DisplayWhen property to Screen Only.
 * 5) Preview the form again. Note that the detail section is blank.

