3 Replies Latest reply on Oct 27, 2011 4:41 PM by philmodjunk

    deleting empty space between cells



      deleting empty space between cells



       First time user here! I hope someone can help me with this:

       Is there some type of autoformatting feature like there is in Excel?  I've tried autosizing a table to delete extra space between cells, though it's effecting how much text is being displayed in each cell. For example, one cell may have only a few lines of text, and the autosizing doesn't effect it.  On the other hand, another cell may have 10 lines of text, and the autosizing allows only a few lines to be displayed.  Is there a way to autosize a table that deletes extra space, but displays all the information of each cell in the table?


      Thanks, and sorry for any confusion! Like I said, I'm VERY new to this program!

        • 1. Re: deleting empty space between cells

          Tables are something defined in Manage | Database | Tables.

          What you are describing is a layout (and we call them "fields" instead of "cells" in FileMaker Wink)

          What "auto-sizing" are you referring to?

          The only option available for using the amount of data entered in a field to resize the field is to use the "sliding and visibility" section of the Inspector's position tab to set a field to "slide up"; "resize enclosing part". This will shrink a field and if you set all other objects below it to slide up and resize it will also remove the resulting empty space. This often requires setting up on layout for data entry where you equip the fields with scroll bars and a second layout where you size the fields very large and set them to slide.

          Key facts about sliding layout objects:

          1. It's only visible in preview mode and when you print/save as PDF...
          2. 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.
          3. Objects in headers and footers will not slide.
          4. Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
          5. Container fields will slide only if Top, Left alignment is specified for it in the data formatting section of the Inspector's data tab.
          6. Consistent side borders are difficult to achieve with sliding fields.
          • 2. Re: deleting empty space between cells

            Thank you very much for your response!  I'm having to transition from Excel, which is proving difficult.  We're still having issues deleting extra space within fields, but will continue trying.  Please let me know if you can think of other ways to resolve this.  Thanks!

            • 3. Re: deleting empty space between cells

              I'd need to know more than what you have described here in order to make any further suggestions.