Dynamically blank all text controls on a form

**simonhorne** · Oct 19th, 2005, 05:19 AM

Hi,

I'd like to know is it possible to do something like the following

VB Code:

For each objcontrol in form.controls
  if objcontrol is a textbox
    objcontrol.text = ""
  end if
Next

Is this possible

**Hack** · Oct 19th, 2005, 05:24 AM

Moved from CodeBank.

This is how you would code it:

VB Code:

Dim ctrl As Control
For ctrl In Me.Controls
  If TypeOf ctrl Is TextBox Then
    ctrl.text =  vbNullString
  End If
Next

**simonhorne** · Oct 19th, 2005, 05:41 AM

Thanks Hack,

I just realised I had posted it in the wrong place. Was browsing through the codebank and hit new thread from there Typeof was the keyword I was looking for

Cheers

**Hack** · Oct 19th, 2005, 06:04 AM

Originally Posted by simonhorne

I just realised I had posted it in the wrong place. Was browsing through the codebank and hit new thread from there

Happens all the time.

Thread: Dynamically blank all text controls on a form

Thread Tools

Display

Dynamically blank all text controls on a form

Re: Dynamically blank all text controls on a form

Re: Dynamically blank all text controls on a form

Re: Dynamically blank all text controls on a form

Posting Permissions