Disable all controls on a form.

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
Setting the form's AllowEdits property to No effectively disables all
controls.

If you want to loop through the controls and disable only the bound ones,
grab the code in this article:
Locking bound controls on a form and subforms
at:
http://allenbrowne.com/ser-56.html
The code calls itself recursively so that any level of subform is handled
also.
 
Do you get what you need if you set Allow Edits, Allow Addititions, and
Allow Deletions to No in the form's properties?
 
Back
Top