This is not something that you would do with conditional formatting.
There are two options:
a) set fields to slide up--a setting in the inspector
b) use a calculation field
Ive tried the sliding, and for some reason it doesn't work
It works. To help you figure out why it didn't work for you, you'd need to describe the design of your layout and exactly what options you selected.
This is what I have
Try Phil's suggestion of a calculation field, call it Label, and put this calculation in there:
@addr= List(address1; address2; city & ", " & state & " " & zip; Country); //make sure you use all the correct names in your DB
"Attn: " & Table::attnField
) //end case
]; //end variables
You can either put this on the layout as a merge field, or you can put this as an auto enter calc, in the Label field, and put that field on the layout (then you could still type into the field and make changes)
edit: Changed calc to add TextStyleAdd to make company name bold
@Phil....says he's using FM12
The "attn:" layout text is what is keeping the fields from sliding up. If you use "Hide object when" to hide this text object when the Attn field is empty, you can set the Attn layout text, the Attn field and all layout objects located below it to "slide up" and to "resize enclosing part".
Key facts about sliding layout objects:
- It's only visible in preview mode and when you print/save as PDF...
- Sliding fields will shrink but not expand.
- 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.
- Objects in headers and footers will not slide.
- Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
- Fields will slide up only if Top alignment is specified for it and will slide left only if Left alignment is specified.
- Consistent side borders are difficult to achieve with sliding fields.
- In FMP13, hidden objects (”Hide object when”) will slide/resize.