Clearing unbound textboxes 1

[Domino2]

I am trying to clear unbound textboxes. I use the code below to hide certain textboxes and labels but cannot find a way to just clear them.

For Each ctl In Me.Controls
If ctl.Tag = "?" Then
ctl.Visible = False
End If
Next

What I want is something like ctl=""

Can it be done? Obviously only textboxes will be tagged for clearing, ie where tag = ??

Thanks

 

[TheAceMan1]

How are ya Domino2 . . .

Perhaps:

[blue]   For Each ctl In Me.Controls
      If ctl.tag = "?" Then
         ctl.Visible = False
      ElseIf ctl.tag = "??" Then
         ctl = ""
      End If
   Next[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Domino2]

Many thanks, that fixed it. Have a good weekend.