Looping through controls looking for nulls

I have a form with 15 text boxes on it. I am looking for an efficient way to loop through all the text boxes looking for nulls before I commit a DB transaction.

I know I can do a series of IF Thens but there has to be a better way. I assume there is a way to loop through the controls so I am looking for a sample that will help me et started. Also is it possible to send the focus to the first textbox error found in the loop?

This will loop through all the textboxes on the form itself (not on another container that is on the form):

VB Code:

For Each txt As TextBox In Me.Controls
  If txt.Text=String.Empty Then DoSomething
Next

Hmmm am I missing something?

Code:

---

      Dim txty As TextBox
        For Each txty In Me.Controls
            If txty.Text = String.Empty Then MsgBox("OOPS")
            Exit Sub
        Next

---

Gives me this error

An unhandled exception of type 'System.InvalidCastException' occurred in RP_6.0.exe

Additional information: Specified cast is not valid.

It then highlights this line For Each txty In Me.Controls. It does this regarless of whether I alter it as I did in my post or use it exactly like you posted it.

Do you have Option Strict on? Try this:

VB Code:

Dim ctrl As Control
        For Each ctrl In Me.Controls
            If typeof ctrl Is Textbox AndAlso DirectCast(ctrl,TextBox).Text=String.Empty Then
                  MsgBox("OOPS")
                  Return
            End If
        Next

Thanks Edneeis that did the trick.