3 Replies Latest reply on Oct 23, 2013 10:25 AM by JaimeHorton

    formatting merge field question



      formatting merge field question


           Hi all 


           ok i have a merge field that has been formatted to slide up when empty. is there any way to have a text label for the merge field that will dissapear when the field is empty ?



        • 1. Re: formatting merge field question

               Make a calculation field with the label data and the data from the merge field.  Your calculation would be something like

               If(IsEmpty(YourMergeField);"";"Label : " & YourMergeField)  

               You can just add the if statement if your merge field is already a calculation.  You would substitute your field name for YourMergeField in the above calculation.

          • 2. Re: formatting merge field question

                 You can use a conditional format expression to make the label text non visible. It can change the color to match the layout back ground or set the font size to more than 100 points in size. (you may need to go larger depending on the size of the text block.)

                 But this still requires the same space on your layout, You won't be able to "resize enclosing part" and remove the blank space occupied by this layout text.

                 To do that, you'd need to replace the layout text with a calculation field that returns the label text when the data field has data and that returns nothing when it is empty. Now you simply have one more field to slide up/resize on your layout.

                 Key facts about sliding layout objects:

            1.           It's only visible in preview mode and when you print/save as PDF...
            3.           Sliding fields will shrink but not expand.
            5.           All layout objects below and in the same layout part as the slide/resize field need to also be set to slide up and resize.
            7.           Objects in headers and footers will not slide.
            9.           Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
            11.           Fields will slide up only if Top alignment is specified for it and will slide left only if Left alignment is specified.
            13.           Consistent side borders are difficult to achieve with sliding fields.
            • 3. Re: formatting merge field question

                   Thanks Guys 


                   The Calculation Field worked out great