Null Text Box

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

Guest

An amount in my report shows a blank when the source is null.
I want to show a zero. So I guess the quextion is ,,, what is the function
that would set an expression to zero if the source expression is zero but
would set the expression to the value of the source expression otherwise.

I apologize for asking such a basic question but I have been searching
Access Help without any result. I wish there was a list of available
functions and better documention of their purpose and use.

Thanks for any help.
 
Oops ... I meant "set an expression to zero if the source expression is null".
Deficient typing skills.
 
Try setting the Format property of the text box to something like this:
0.00;-0.00;0.00;0.00
 
Rhinoc24 said:
An amount in my report shows a blank when the source is null.
I want to show a zero. So I guess the quextion is ,,, what is the function
that would set an expression to zero if the source expression is zero but
would set the expression to the value of the source expression otherwise.

I apologize for asking such a basic question but I have been searching
Access Help without any result. I wish there was a list of available
functions and better documention of their purpose and use.
Click to expand...


If you want ot use a zero instead of Null in calculations,
then you can use the Nz function to do this. E.g. fld1 +
Nz(fld2, 0)

If you only want to display a zero for Null values, another
way would be to use a custom format in a text box's Format
property. E.g. for an integer field, you might use the
format #;;0;"0"
 
Back
Top