IsEmpty on textbox does not work - what to use instead

[webster188]

Hi,

I have created a very simple userform with one textbox and a "back" and "next" commandbutton.
The "next" commandbutton only becomes active when the textbox is not empty.
Unfortunately, even when the textbox is empty, the commandbutton is alway enabled.
I found out that textbox.value="" is not considered as Empty.

What syntax should I use instead to make this work?

 

[Sektor]

Try TextBox.Text

 

[AlphaFrog]

Other ideas...

TextBox1.Value = vbNullString

Len(TextBox1.Value) = 0

 

[webster188]

Does not change a thing

Syntax used is

If IsEmpty(My.textbox.text)=false then
' commandbutton active
End if

Even if the textbox is empty, commandbutton active is always executed.

 

[Sektor]

If IsEmpty(M[B][COLOR="Red"]e[/COLOR][/B].Textbox) then
' commandbutton active
End if

 

[AlphaFrog]

This worked for me...

Private Sub TextBox1_Change()
    CommandButton1.Enabled = TextBox1.Value <> vbNullString
End Sub

 

[webster188]

vbNullString works like a charm.

Thanks for the solution.

 

[Sektor]

Instead of vbNullString you could use ""

 

[Jon Peltier]

Since there is always confusion about vbNullString, I check whether the length of the text is zero:

If Len(Me.TextBox1.Text) = 0 Then