Form visible in Design View, but blank in Form View

Question

My form is showing up in design, but not form view. There are 700+ records.

In Design View -> Data, the Record Source is:

SELECT act.* FROM act;

This query shows all records in Query view.

There are no filters, and Allow Form View is set to Yes.

What is causing my form not to show?

EDIT: I'm noticing that the form is extremely wide. There isn't a width setting, but in Design view with window maximized I have to scroll way over to see the right edge. Would this have anything to do with it?

Answer 1

This link might help you. I remember having this issue and it was because of a read-only query.

Why does my form go completely blank?

Here is an excerpt that lists the main conditions why this could happen:

Condition (a) can be triggered in several ways. Examples:

 - The form's Data Entry property is set to Yes. (This means the form shows no existing records, i.e. it is for entering new ones only.)
 - The form has a Filter applied (or is opened with a WhereCondition) that yields no records.
 - The form is based on a query where the criteria yield no records.
 - The form is based on a table that has no records.

Condition (b) can be also be triggered by several things:
 - The form's Allow Additions property is set to No.
 - The form's Recordset Type property is set to something other than Dynaset.
 - The form is based on a read-only query. (If you cannot add a record directly to your query, see Why is my query read-only?)