formatting merge field question
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 ?
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.
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:
The Calculation Field worked out great
Retrieving data ...