Default Values

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

I was wondering if there was a way to have a textbox on a
report return a "0" if there is a Null value associated
with it. If so how would I do this?

Thanks,
Chad
 
Chad said:
I was wondering if there was a way to have a textbox on a
report return a "0" if there is a Null value associated
with it. If so how would I do this?
Click to expand...

Several ways.

One is to use a custom format with the text box. Here's a
simple number format #0;-#0;0;"0"
The trick here is that a format can have four parts. I.e.
different formats for positive, negative, zero and Null
values.

A different way is to set the text box to an expression:
=Nz(fieldname, 0)
ust make sure that the name of the text box is different
than the name of the field it's displaying.
 
Back
Top