Member Avatar for Sturdy

Hello masters,

I want to know how to check an empty textbox in the form.
I can check it by assign Text1.Text = "".
But i have many textbox in form.

Thank you in advance

  • 2 Contributors
  • 2 Replies
  • 467 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by Sturdy
Member Avatar for Jx_Man

Try this :

Dim ctrAs Control

For Each ctr In Me.Controls
   If TypeOf ctr Is TextBox Then
      If ctr.Text= vbNullString Then
         MsgBox "Textbox empty"

         ctr.SetFocus

         Exit Sub

      End If
  End If
Next ctr
Edited by Jx_Man because: n/a
commented: Excellent suggestions based on in depth knowledge of the language. +5
commented: It's a wonderful code sir :) +2
Member Avatar for Sturdy

Thank you sir for wonderful code..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.