Null values in List Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have placed List boxes in a report that each show a sum
from seperate queries, but when there are no results from
the queries, the field is left blank in the report
(Null). I would like those convert those "Null" values to
display a "0".

I have tried to use the IIf function and Nz([control])
function in the query, but that doesn't work.

Is there some code I can use on the "on Format" property
of the detail section to, perhaps an If statement, to make
these controls display a "0" when they are null? Is this
possible with List boxes?

Thanks
 
Back
Top