F
Fons Ponsioen
Give the Nz(variant[, valueifnull]) funstion a try.
Hope this helps.
Fons
controls bound to these fields and will print #error when
the query field has no value (this I understand). What I
want to do is print "0" if the field has no data, or the
field value otherwise.
data, but the field does not. So, what I need is a
field.hasdata property?
Hope this helps.
Fons
fields may or may not return a value. The report has
controls bound to these fields and will print #error when
the query field has no value (this I understand). What I
want to do is print "0" if the field has no data, or the
field value otherwise.
still get #error. I assume this is because the report has
data, but the field does not. So, what I need is a
field.hasdata property?