ACC: How to Make a Subform Uneditable and Unenterable

• 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 give focus to the subform by clicking it with the mouse. To prevent this from happening, you must make the subform unenterable. The text below describes the steps to do this. An uneditable and unenterable subform appears as a "label" for information.

MORE INFORMATION

To make a subform uneditable and unenterable, follow these steps:

1. Open the main form in Design view.

2. Click the mouse once on the subform object to select it.

3. If it is not already showing, 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
   

REFERENCES

For more information about this topic, search the Help Index for "locking controls."