ado recordset to textbox =invalid use of null 1

[TRYP]

offending code :

txtAddr2 = resultSetName!STUDENT_LAST_NAME

love note:

invalid use of null (error # 94)

help:

any you can spare !

 

[listener22]

You can do the following:

txtAddr2 = "" & resultSetName!STUDENT_LAST_NAME


The empty string should solve any problems with null records.

 

[dpaulson]

You can use the immediate if function
IIf(expr, truepart, falsepart)

txtAddr2 = iif(isnull(resultSetName!STUDENT_LAST_NAME),"",resultSetName!STUDENT_LAST_NAME)

 

[TRYP]

Thanks sooooo much
it worked like a charm...
uh, why did it work ????