empty text box

[HansBades]

I have an empty text box on a form not bound to anything. I have a command button next to it. When the user enters in a value and clicks the command button it will insert the value in the text box into a listbox. Before the command button executes, I have it check to see if the text box value is null. I have tried me.textboxname.value="", isnull(me.textboxname), vbNullstring, but no matter what I try it still inserts a blank value into the list box. Any idea why? How can I get the subroutine to recognize the text box is blank and not perform the routine? Thanks.

[orange]

Try: in the OnClick event


If nz(Me.textboxname,"")= "" Then 'textbox is empty

[Welshgasman]

Where are you checking?
Sometimes you have to use the .Text value ?, not often, but sometimes.

[ArviLaanemets]

Text Box itself can't have Null value. In case of bound Text Box, the bound field can have Null value (when allowed). An unbound Text Box can have NullString value instead, when empty.

[Micron]

The question was how to stop zls or null being added into listbox row? Would have to see the code to know why. Maybe just Exit Sub is needed after the test.

[HansBades]

Thank you everyone. I got it working and found the comments very instructive. Thank you again.