I have the following formula -

{OITM.U_Spec1}+ ChrW(13)+{OITM.U_Spec2}+ChrW(13)+{OITM.U_Spec3}+ChrW(13)+{OITM.U_Spec4} in my details section.

- which works fine and will display each Spec underneath each other.

However, it only displays when all 4 specs are present. When an item only has U_Spec1,U_Spec2 and U_Spec3 (without U_Spec4) - nothing displays.

 

How can I change the formula to display in cases like that?

 

Regards

 

Danie

 

Thank you for the reply. It worked for me.

 

However, since this formula is in the details section I would like for the records to be directly underneath each other. At the moment I might get 4 lines for items 1 and 2, 2 lines for item 3 and so on. Problem is - when there is only 2 or 3 lines then I get a blank line(s) for the missing (Null value) specs.

 

My formula is imbedded in a test field which is set 'Suppress Embedded Field blank lines' and 'Can grow' is enabled. In the section expert (Details) I have 'Suppress blank section' ticked.

 

Formula set to 'Default values for nulls'

 

Am I missing a tick somewhere?

 

Regards

 

Thank you - that worked for me.

 

Regards