1. I cannot tell from what you have posted thus far. I suggest posting your script here in the forum and describing your database design in more detail.
2. For printing, preview or save as PDF, you can set fields to shrink but not to enlarge. This can be done by selecting Sliding and Visibility options in the Inspector. The trick is to set the fields much taller than you ever expect to need. See additional info listed at the end of this comment.
3. Open Manage | Database | Fields and find this field's definition. Double click it. Select the calculation auto enter option. Enter this calculation: TextFormatRemove ( self ). Clear the do not replace existing values check box. This will fix this for new records but not for existing records. You can use this function with Replace Field Contents to remove the pasted formatting from your existing records.
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post A Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here. (with this approach, you can get multiple script steps on the same line, please edit the pasted text by inserting some returns to separate those steps.)
- If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.
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.