Add Text in an IIf Statement 1

[bethabernathy]

Hi - Once Again... This forum is AWESOME. I have the following expression in a text box:

=IIf([IncidentDescription]=Null," ",[IncidentDescription])

Is there a way to set it so that If the "IncidentDescription" is not Null, then the title Incident Description appears prior to the data in the record. For Example:

Incident Description: Skied into a tree.
(Title) [IncidentDescription]

Thanks, Beth beth@integratedresourcemgmt.com

 

[JohnLowell]

It's me again.

Use this:

=IIf([IncidentDescription]=Null," ","Incident Description " & [IncidentDescription])

 

[bethabernathy]

Hi John: Thanks!! I tried that and now the title "Incident Description" appears at every record. I am thinking that if I set up the title in its' own text box using syntax that says:

=IIf([IncidentDescription]=Is Not Null, "Incident Description:&quot

But, of course, this isn't working. I don't think it likes the "Is Not Null". Any ideas?

Thanks Again, Beth beth@integratedresourcemgmt.com

 

[JohnLowell]

Set it up exactly as the other one:

=IIf([IncidentDescription]=Null," ","Incident Description: &quot

 

[bethabernathy]

Hi - The title "Incident Description: " is repeating in each record even if there is no "IncidentDescription". That is why I am thinking that If "IncidentDescription" is not null then I want to see the title.

Do you know the syntax for "is not null" in a text box?

Thanks, Beth beth@integratedresourcemgmt.com

 

[JohnLowell]

Try using Not isnull

 

[bethabernathy]

O.K. This is working, I think:

=IIf([IncidentDescription]>" ","Incident Description: &quot

What a Pain! Thanks for your help.

Beth beth@integratedresourcemgmt.com

 

[JohnLowell]

You could also try:

=IIf(IsNull([IncidentDescription]) or Len([IncidentDescription]) = 0," ","Incident Description: &quot

 

[bethabernathy]

Thanks for your AWESOME help. Much Appreciated. Beth beth@integratedresourcemgmt.com