textboxs 1

[ninash]

I need to preform the same process on many text boxes. is there a way of setting up a loop to process them instead of selecting each one in turn then performing the action I need to do.

It would shorten my code heaps if someone could show me the light

 

[euskadi]

Check out this thread... someone asked a similar question about combo boxes...

thread707-227108

 

[acron]

You could use the following to go through all controls and apply your processing if they are TextBoxes.

    Dim ctrl As Control
    For Each ctrl In Me.Controls
        If TypeName(ctrl) = "TextBox" Then
            ' Procees the textbox here
        End If
    Next

AC

 

[ninash]

Thanks Acron

That did the job I hope the star serves you well

 

[euskadi]

Yeah, thanks Acron. The method I suggested in the other thread works... but it's a messy workaround.