ACC: How to Make a Subform Uneditable and Unenterable (95923)



The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97

This article was previously published under Q95923
Novice: Requires knowledge of the user interface on single-user computers.

SUMMARY

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:
  1. Open the main form in Design view.
  2. Click the pointer once on the subform object to select it.
  3. Click Properties on the View menu to display the Subform/Subreport property sheet.
  4. 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.

Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbhowto kbusage KB95923