Loop through all controls on a form

S

SHIPP

I would like to loop though all controls on a form to disable all of them. Anybody have the code to do this. I'm using Access 97.
 
J

Jason

-----Original Message-----
I would like to loop though all controls on a form to
Click to expand...
disable all of them. Anybody have the code to do this. I'm
using Access 97.
.
Click to expand...


Dim Frm as Form, Ctl as Control

Set Frm = Me
For Each Ctl In Frm
Ctl.Enabled = False
Next Ctl

Jason
 
M

Marshall Barton

SHIPP said:
I would like to loop though all controls on a form to disable all of them. Anybody have the code to do this. I'm using Access 97.
Click to expand...


Some controls can not be enabled/disabled so you either have
to check the controls type or ignore the errors that occur.
Here's one way:

Dim ctl As Control
On Error Resume Next
For Each ctl in Me.Controls
ctl.Enabled = False
Next ctl
 
Top