How to check if textbox is empty for If statement.

[behnam]

Hey all,



i have a textbox called textbx1 and in this field the user enters four numbers representing the year. How can i say as an if statement if the year field is empty.

I tried the following

If textbx1="" Then

But this does not work.

Thanks for your time.

[ranman256]

if isNull(textbx1) then

[Missinglinq]

Your original attempt

If textbx1="" Then

is checking to see if there is a Zero-Length String in textbx1, The vast majority of the time, unless data is being imported from another program, a 'blank' Control in Access is Null, not a ZLS.

ranman256's code

if isNull(textbx1) then

is checking for that Null.

Many experienced developers will check for both...Zero-Length Strings and Nulls. This can be done a number of ways:

If Nz(Me.textbx1, "") = "" Then

and

If (Me.textbx1 & "") = "" Then

being just two of them.

Linq ;0)>

[GraeagleBill]

And then there's always:

if len(me.txtbx1 & "") > 0 then 'That gets the case of both Null and ZLS