Microsoft KB Archive/209734

= ACC2000: Form Opened in Form View Is Completely Blank =

Article ID: 209734

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209734



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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
When you open a form in Form view, it is completely blank. The form appears to have neither controls nor text.



CAUSE
This behavior can be caused by several different things, such as:
 * The record source of the form doesn't return any records.
 * The form header or form footer section is too large, which prevents the detail section from being displayed.
 * The Visible property of the detail section is set to No.



Record Source Doesn't Return Records
If the form is based on a query, run the query to make sure that the query returns records. If the query only returns a bar with the field names, there is a problem with the query that needs to be fixed.

Form Header/Footer Is Too Large
The form header and footer are displayed before the detail section. If the Height property of either one of these sections is larger than the display area of the Form window, the form will be displayed as an empty window. To correct this, check the Height property for both the form header and the form footer in Design view of the form.

The page header and footer do not cause this same behavior.

The Visible Property of the Detail Section Is Set to No
Setting the Visible property of any object to No will hide the object. Verify that the Visible property of the detail section is set to Yes in the property sheet of the form.



MORE INFORMATION
Some other situations that can cause a form's record source to return no data are as follows:
 * The form is based on a query that contains a one-to-many join, and the query returns no records.
 * The form is not updateable. It is a read-only form with the AllowUpdating property set to No Tables, or it is a static form that displays results by using a GROUP BY clause or a DISTINCT operator.
 * The form is based on a query that contains a one-to-one join, and one of the tables is in a read-only database.
 * The form is based on a query that contains a many-to-one inner join, and the query does not contain all the joined columns of the many-side table.
 * The form is based on a query that includes an updateable remote table but does not include all the columns that make up the primary key.
 * The form is read-only and is based on an empty table.

