Here's my situation: I have a colon as a text object (not a field) between two text fields. If there is not text in the two fields on either side of the colon, I do not want the colon to print - is it possible to write a script or somehow make it so that the colon will not print if there is no text in a surrounding field? I'm new at this so I am still learning - but the sooner I can find out whether this is possible or not the better, which is why I'm jumping to a forum. Thanks for your help!

SC

Hi SC,

Since you want the colon to be conditional, it must be a calculation. Create a calculation (text) with:

If(

not IsEmpty( text1 ) and

not IsEmpty( text2 ) ;

":" )

Place this calculation between the fields instead.

LaRetta

Lifesaver! Thank you - this worked beautifully and gave me more insight into expanding my template using this type of calculation.

Thanks again.

SC

You can also use <<merge fields>> in your print layout. If they have no data in them, they shrink to nothing. They will also shrink to the size needed to display the field.