ACC: How to Make a Subform Uneditable and Unenterable

ID: Q95923

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SUMMARY

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

If a subform is uneditable, a user cannot make any changes to the subform. However, a user can still give focus to the subform by clicking it with the pointer. To prevent this from happening, make the subform unenterable. To do so, follow these steps:

Open the main form in Design view.

Click the pointer once on the subform object to select it.

Click Properties on the View menu to display the Subform/Subreport property sheet.

Change the Subform/Subreport properties as follows:


      Subform/Subreport
      -----------------
      Enabled: No
      Locked:  Yes

NOTE: You can use an uneditable and unenterable subform as a "label" for information.

Additional query words: noneditable nonenterable

Keywords : kbusage FmsSubf
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbhowto