Disable all text boxes in a Form

[OOzy]

Dears,

How can I disable all text boxes in a form (Enable=False) programmatically without typing:

a.Enabled=False
b.Enabled=False
c.Enabled=False
d.Enabled=False
e.Enabled=False

 

[GHolden]

Hi, you can use the following...

Dim ctrl As Control

'loop through all form controls
For Each ctrl In Me.Controls
  'if control is a Text Box
  If TypeOf ctrl Is TextBox Then
      'set enabled to false
      ctrl.Enabled = False
  End If
Next ctrl

There are two ways to write error-free programs; only the third one works.

 

[AccessGuruCarl]

OOzy,

A simple search would have given you plenty of examples.

Try this link, scroll down and take a look at the code I posted and followed up by TheAceMan1.

http://www.tek-tips.com/viewthread.cfm?qid=909802

Search Access Help... for

Type ... ControlType in the VBE window
highlight it, hit F1

Enjoy...





AccessGuruCarl
Programmers helping programmers
you can't find a better site.

 

[OOzy]

Thank you all. Your posts were really helpful and I am sorry for not searching befor posting.