ACC: Cannot Open Datasheet as a Pop-Up or Modal Form (95/97) (142539)

The information in this article applies to:

Microsoft Access for Windows 95 7.0
Microsoft Access 97

This article was previously published under Q142539

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

SYMPTOMS

A form with its DefaultView property set to Datasheet and its Modal and PopUp properties set to Yes does not open with all three properties applied.

In Microsoft Access 97, the form opens in Datasheet view, but the Modal and PopUp property settings are ignored.

In Microsoft Access 7.0, the form opens as a pop-up form in Form view, but the DefaultView and Modal property settings are ignored.

CAUSE

Only forms that open in Form view can be modal and pop-up. This is by design.

RESOLUTION

If you want a form in Datasheet view to be displayed as a modal or pop-up form, consider placing the datasheet form as a subform in an unbound main form. The main form can be displayed in Form view as a modal or pop-up form. This also gives you the ability to add other features to your form, such as a Close command button, that you could not add otherwise.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb.

Open the Customers form in Design view and set the following properties:

      DefaultView: Datasheet
      Modal: Yes
      PopUp: Yes

Close and save the form.
In the Database window, click the Customers form, and then click Open. Note that you see the results described earlier.

REFERENCES

For more information about form properties, search for "properties, forms and subforms" using the Microsoft Access 97 Help Index.

Modification Type:	Major	Last Reviewed:	10/22/2003
Keywords:	kbprb kbusage KB142539