Comment Text Field 1

[Roscoe307]

I need to create a formula that will combine four comment fields into one. I tried to concatenate them like this -

{AWRD_TXT}&{PLAN_TXT}&{REQ_TXT}&{SOL_TXT}

but the formula field shows up blank in the report even though the {PLAN_TXT} field has data. How can I get the formula to display the text in the report even if some of the fields are empty?

 

[lbass]

(
if isnull({AWRD_TXT}) then
"" else
{AWRD_TXT}
) &
(
if isnull({PLAN_TXT}) then
"" else
{PLAN_TXT}
)&
(
if isnull({REQ_TXT}) then
"" else
{REQ_TXT}
)&
(
if isnull({SOL_TXT}) then
"" else
{SQL_TXT}
)

-LB

 

[Roscoe307]

Thanks so much lbass!!

 

[CoSpringsGuy]

Would it have been possible to select the "Use Default Values for Null" in the formula editor to avoid the If statement coding suggestion?
Not correcting the response because I know that works well but I am curious if what I usually do would cause problems that I am not aware of....

Thanks

 

[lbass]

It should work if you choose that option. I don't ordinarily check that for various reasons, e.g., because I want to set a different default if a date field is null because of how I need a comparison to work.

-LB