Null Text Box

[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.

 

[Guest]

Oops ... I meant "set an expression to zero if the source expression is null".
Deficient typing skills.

 

[Allen Browne]

Try setting the Format property of the text box to something like this:
0.00;-0.00;0.00;0.00

 

[Marshall Barton]

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.

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"

 

[Rob]

View the code of the report and a conditional against that object.