ACC2000: Form Opened in Form View Is Completely Blank (209734)


The information in this article applies to:

  • Microsoft Access 2000
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.

RESOLUTION

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.

REFERENCES

For more information about blank forms, click Microsoft Access Help on the Help menu, type troubleshoot forms in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbprb kbusage KB209734
©2004 Microsoft Corporation. All rights reserved.