ACC2: No Visible Property for Form Page Header/Footer Sections

• Microsoft Access version 2.0

SYMPTOMS

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

In Microsoft Access version 2.0, form page header and page footer sections do not have a Visible property as they do in Microsoft Access version 1.x.

If you convert a form that was created in version 1.x to version 2.0, and that form has a page header or page footer section whose Visible property is set to No, there is no way in version 2.0 to set the Visible property for that section back to Yes.

CAUSE

In Microsoft Access version 2.0, the Visible property can be set at run time for the form header, form footer, and detail sections. As a side effect, the Visible property is disabled for the page header and page footer sections.

RESOLUTION

One workaround for this problem is to create a new form in Microsoft Access version 2.0 and then copy all of the controls from the version 1.x form into the new form. When you do this, the page header and page footer sections in the new form will be visible.

Another workaround is to use a report to print the data instead of a form. (Because the page header and page footer sections are used only when you print the form, you could easily substitute a report instead.) Page header and page footer sections in reports in Microsoft Access version 2.0 do have a Visible property. To save a form as a report, open the form in Design view, and then choose Save As Report from the File menu.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.

REFERENCES

For more information about the Visible property, search for "Visible," and then "Visible Property" using the Microsoft Access Help menu.