forms - 表单在设计 View 中可见，但在表单 View 中为空白

Question

我的表单显示在设计中，但没有显示在表单 View 中。有 700 多条记录。

在 Design View -> Data , Record Source是:

SELECT act.* FROM act;

此查询在查询 View 中显示所有记录。

没有过滤器，还有 Allow Form View设置为是。

是什么导致我的表格不显示？

编辑:我注意到表格非常宽。没有宽度设置，但在窗口最大化的设计 View 中，我必须滚动才能看到右边缘。这会与它有什么关系吗？

Answer 1

此链接可能对您有所帮助。我记得有这个问题，这是因为只读查询。

Why does my form go completely blank?

这是一个摘录，列出了为什么会发生这种情况的主要条件:

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?)