Form fields disappear in Details section

M

Maury Markowitz

I have a form. It has worked well for months. Now I add a footer with some
totals/averages. It worked for a while while making these changes. Now it
doesn't work.

The fields in the Details section will not appear. They are marked
"visible". They are "enabled". They just don't show up. There appears to be
nothing you can set on either the form or Details that could explain this.

If I simply drag the fields into the header, they appear. In the footer,
they appear. In the Details, they do not appear.

Huh?
 
R

Rick Brandt

Maury said:
I have a form. It has worked well for months. Now I add a footer with
some totals/averages. It worked for a while while making these
changes. Now it doesn't work.

The fields in the Details section will not appear. They are marked
"visible". They are "enabled". They just don't show up. There appears
to be nothing you can set on either the form or Details that could
explain this.

If I simply drag the fields into the header, they appear. In the
footer, they appear. In the Details, they do not appear.

Huh?
Click to expand...

The detail section of a form is completetly blank when both of the following are
true...

There are no existing records being displayed.

The form and/or its RecordSource do not allow new records to be added.

When you normally look at a "blank form" and see all of the empty controls it is
when you are positioned at the "new record" location of the form's RecordSet. A
form where new records are not allowed doesn't have this location so all it can
show you are controls populated with data from existing records. When there are
no records or you impose a filter that has no matches, then all the form can do
is go blank.
 
M

Maury Markowitz

Rick Brandt said:
The detail section of a form is completetly blank when both of the following are
true...

There are no existing records being displayed.

The form and/or its RecordSource do not allow new records to be added.
Click to expand...

Neither of these are true. The recordset is editable, and there is an active
record being displayed.
When you normally look at a "blank form" and see all of the empty controls it is
when you are positioned at the "new record" location of the form's RecordSet. A
form where new records are not allowed doesn't have this location so all it can
show you are controls populated with data from existing records. When there are
no records or you impose a filter that has no matches, then all the form can do
is go blank.
Click to expand...

I think you misunderstand -- the fields disappear entirely. Not "empty",
"gone".

Maury
 
M

Maury Markowitz

Further info: it happens as soon as you say Send to Back or Bring Forward on
any field. That field will now disappear, and the next flip from design to
display and back will make the rest disappear. There is no way to get them
back that I can find.

This is a bug.
 
R

Rick Brandt

Maury Markowitz said:
Neither of these are true. The recordset is editable, and there is an active
record being displayed.
Click to expand...

I have seen cases where the imposition of a filter could make a normally
editable Recordset become non-editable.
I think you misunderstand -- the fields disappear entirely. Not "empty",
"gone".
Click to expand...

That is exactly what I was describing, a totally blank detail section.
Having controls in the form footer and header still appear is consistent
with the behavior I am describing. How can an active record be displayed
if you have no controls visible in your detail section? Do you have the
navigation buttons displayed? If so do they indicate "Record 1 of ..."?
 
Top