show/do not show text box if field is null

[eric.l.bohon]

alcon,

can not seem to remember how to do this. I have a text box in a report with the following expression:

="a. " & nz([a],nz(,nz([c])
="c. " & nz([a],nz(,nz([c])
="d. " & nz([a],nz(,nz([c])

and so on and so on.

is there a way that if the field c is blank that nothing shows up instead of just c showing up and nothing else.

 

[VBACO]

If I am understanding you correctly, couldnt you just add an NZ before the "c."?

 

[HiTechCoach]

Try using a + as the concatenation operator.

="a. " + nz([a],nz(,nz([c])))

 

[eric.l.bohon]

both of those recommendations did not work.

I even tried multiple things and still did not work. the one that did not have anything selected for it still showed up with just the letter and nothing else.

 

[HiTechCoach]

What about one of these:

="a. " + [a]

or

=IIF( IsNull([a]) ,Null, "a. " & [a],)

or

=IIF( IsNull([a]) ,"", "a. " & [a],)

 

[xenou]

is there a way that if the field c is blank that nothing shows up instead of just c showing up and nothing else.

So what if fields c and b are both Null. Or c and a but not b? Or a and b but not c? This is very cryptic. In any case, you cannot have nothing showing up with three fields being concatenated, unless all three are Null/Blank.