I'm trying to design a layout for a database in Filemaker that will be used for making a print copy of a portion of the database. Here is the problem:

One field in the database (a text field) has huge variations in how much information is stored in each record. For example, the first record might have a short phrase while the next record might have a long paragraph. What I'd like to do is to set up the layout so it resizes the box so that it isn't any longer than the length of the record being displayed. If I can't figure out a way to do this, then I need to make the field box in the layout big enough to fit the longest record, which results in LOTS of blank space when there is a short record mixed in. Is there any way to do this?

Thanks!

Pete

Sliding/printing could have been made for you!

On the print layout set the field to be longer than the longest text you will encounter.

Select this field and then select format from the menu bar

Select sliding/printing, tick the "sliding up based on:" and either "all above" or "only directly above" also check "also reduce the size of the enclosing part"

The results will not be visible in browse mode, only in preview or the actual print.