Removing blank spaces in printoutsOften, the amount of information in the fields in your database varies. When you print, FileMaker Pro can shrink field boundaries and shift objects to the left or up on your layout to close up the blank space caused when the information in a field doesn't fill the field boundary.You can slide any object, including fields, portals, other objects, and even layout parts. Here is how certain objects slide:
• Fields shrink to eliminate empty space within field boundaries. A field can also slide if there is a sliding or shrinking field above or to the left of the field.
• Non-field objects, like a horizontal line or a text object, can slide if there is a sliding field above or to the left of the objects. When a non-field object slides, it moves to another place on the layout but it doesn't shrink.
• Portals slide like any other non-field object, but objects within a portal can't slide. If you specify that a portal slides up and the enclosing part shrink, FileMaker Pro omits empty portal rows.
• You can set layout parts to shrink when the fields in them slide up. Headers, footers, title headers, and title footers never shrink or slide up. Don't set a part to shrink on a layout that requires fixed vertical spacing, like labels.
1. In Layout mode, select both the objects you want to slide and the left-most (or top-most) field that you want the other objects to slide into so it can shrink.
2.
Note This option maintains consistent vertical spacing among columns and repeating fields. Sliding up based on, and click All objects above Note This option allows the spacing in a column to adjust independently of other columns and repeating fields. Sliding up based on, and click Only objects directly above
4. To see the effects of the sliding options you set, choose Preview from the Mode pop-up menu at the bottom of the document window.
2.
• In Layout mode, choose View menu > Show > Sliding Objects to see which objects slide and in which directions.
• Be careful when setting sliding options for repeating fields. If some repeating fields are empty and the space is removed by sliding, then adjoining data in different repeating fields may no longer be in proper alignment.
• If your database includes one or more fields that display Japanese text, you can trim extra spaces between characters with the TrimAll function. For each field that contains Japanese data that you want to trim, create a calculation field that uses the TrimAll function to trim that field, and then place that field on your layout. For more information, see TrimAll function.