Microsoft KB Archive/229969

= ACC2000: Property Sheet Is Open in Form View (Browse Mode) =

Article ID: Q229969

The information in this article applies to:


 * Microsoft Access 2000

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

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

SYMPTOMS
When you open a form in Form view (Browse mode), a property sheet is displayed.

CAUSE
This is by design. In Microsoft Access 2000, you can set properties for a form, a section, or a control while viewing the data for a form. This feature is new to Access 2000.

RESOLUTION
If you want to prevent the property sheet from showing in Form view, set the AllowDesignChanges property of the form to Design View Only.

If you want to make the property sheet available in Form view, set the AllowDesignChanges property of the form to All Views.

To set the AllowDesignChanges property, follow these steps:

1. Open the form in Design view.

2. On the View menu, click Properties.

3. On the Edit menu, click Select Form.

4. In the property sheet, the AllowDesignChanges property is located on the

Other tab as well as on the All Tab.

MORE INFORMATION
The following two factors determine whether the property sheet will be available and showing when you open a form in Browse mode.


 * If you set the AllowDesignChanges property to All Views, the property sheet will be available in Design view, Single Form view, Continuous Forms view, and Datasheet view.
 * If you leave the property sheet open when you close the design of a form, the next time you open a form that has the AllowDesignChanges property set to All Views in Browse mode, the property sheet will automatically open in its last location.

NOTE: The default setting for AllowDesignChanges in new forms is All Views.

How to Set Properties in Browse Mode
To set the properties for a specific control while viewing the data on a form, click the control whose properties you want to set. Note that because you are in Browse mode, you cannot set the properties of a label control because a label cannot receive the focus.

To set the properties for a section or of the form itself while viewing the data on the form, click in a blank portion of the form. The first click will show the properties for the section. A second click will show the properties of the form.

Steps to Reproduce Behavior
1. Open the sample database Northwind.mdb.

2. Open the Categories form in Design view.

3. On the View menu, click Properties.

4. On the Edit menu, click Select Form to show the form's property sheet.

5. Click the Other tab.

6. Change the AllowDesignChanges property to All Views.

7. Save and close the form. Be sure to leave the property sheet open in the

design of the form when you close the form. 8. Open the Categories form in Form view.

Note that the property sheet is open.

Additional query words: prb

Keywords         : kbdta Version          : WINDOWS:2000 Platform         : WINDOWS Issue type       : kbprb