how do you code a 2 field If statment

[Jon123]

If Me.text1 IsNot Null and Me. text2 IsNull then

thanks

jon

 

[ajetrumpet]

If Me.text1 IsNot Null and Me. text2 IsNull then

correction?...

if not isnull(me.text1) AND isnull(me.text2) then

 

[ezfriend]

You can also use the

If IsNull(me.text1) = False and IsNull(me.text2) = True then

 

[ajetrumpet]

Friend,

I believe the boolean portions of this argument is optional. Just pointing out.

 

[Brianwarnock]

Friend,

I believe the boolean portions of this argument is optional. Just pointing out.

He has to put the false in otherwise he would be looking for me.text1 to be null, but hey what a wlong winded way to write it especially as you had allready supplied an answer.

Brian

 

[ajetrumpet]

i think i've spoken enough on this thread. good luck to the OP.