[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 742
  • Last Modified:

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
0
daniellyh
Asked:
daniellyh
1 Solution
 
william_jwdCommented:
just give

text1.text = "" & objrec1!field1
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now