How to test null value

[Programming]

the following code gives me error if the text box is empty

Dim JobDescription_var as String
JobDescription_var = Me.JobDescription

I think I should use Nz but I don't know how.
Please help.

 

[arnelgp]

JobDescription_var = nz(Me.JobDescription, "")

or

JobDescription_var = Me.JobDescription & ""

 

[Gasman]

the following code gives me error if the text box is empty

Dim JobDescription_var as String
JobDescription_var = Me.JobDescription

I think I should use Nz but I don't know how.
Please help.

Ever heard of Google?
Search here