convert null value into space

hi,
when i load a "null" value from a field in a table into a control, for e.g a text box,or listview, it will give me error of
"Type Mismatch".any way or syntax that can "convert" the null value into a valid space that can be stored by a
control?any solution for this?

i dun wan to use long statement like:
      if isnull(objrec1!field1)=true then text1=" "


thx.
daniel
LVL 1
daniellyhAsked:
Who is Participating?
 
william_jwdConnect With a Mentor Commented:
just give

text1.text = "" & objrec1!field1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.