Making Text Labels Not Show Up If Corresponding Vale Is Null/0. 2

[MSWhat]

Hi, all.

I'm wondering if it is possible to set some code/formatting to make it such that the text lable does not show up on a report if its corresponding value is either null or zero. For example, if my report looked like this:

Number of red popsicles purchased: 17
Number of blue popsicles purchased: 0

Is there a way to make "Number of blue popsicles purchased" not show up since it's value is 0. Right now, I've made it so that there is a conditional formating set for the form that If the value for popsicles purchased is exactly zero then the text is white (so you don't see the zero at all).

Thanks in advance for your help.

 

[danvlas]

The correct expression is:
=IIF(Not IsNull([AM]), "AM: " & [AM], Null)

But, simpler:

="AM: " + [AM]

If [AM] is null, the entire expression is null.

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[MSWhat]

Thanks for your help, Danvlas, but I don't want the "AM" to show up if the expression is null. However, I did (accidentally) figure it out. The code is:

=IIF([AM], "AM: " &[AM],null)

 

[danvlas]

AM:" & Null will show AM:

"AM:" + Null will show nothing

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[MSWhat]

My previously posted code is working exactly as I hope; "AM: __________" shows up (with the underlined space filled in by the specific Asset Manager, populated by [AM]) only if there is a value entered in the AM field from my table/form. If there isn't, nothing shows up, including the "AM:". That's what I was trying to do. Thanks for the suggestions, Danvlas.