Jump to content

Expanding a field when printing.

This topic is 2007 days old. Please don't post here. Open a new topic instead.

Recommended Posts



I am in a bit of a pickle here. I have a small database implemented in FM11 that records information about clients and some notes made by staff. I have to add a print out feature that produces a print out of certain information from the database, however, the document produced must also allow for additional hand written notes to be written - it will later be used in an interview and/or filed in a paper file.


The first page of the document is just information from database so is fine. Page 2 however consists primarily of 2 boxes (two different sets of notes) and a small section at the bottom for the signature of a supervisor and filing information. 


Either/both of the fields the boxes are populated from could be empty, have a small amount of text or have a large amount of text.  Both boxes need to have a minimum size below which they will not shrink. Below is a - pretty crummy - attempt to draw what the print layout of page two should look like. At a minimum this page should always fill a single A4 page. and the supervisor section should always be at the bottom of the page.


No Text or                

a small amount         Lots of text.

(minimum size)         (any reasonable length)     

 ______                    ______

|            |                  |            |

|______|                  |            |  

_______                  |______|  

|            |                  _______

|            |                  |            |

|______|                  |            |

++++ ++                   |            |


                                ++++ ++


Top and bottom boxes should be independent. One could stay minimum size while the other grew many times normal size.

If the text in either box is too big for the minimum size then it is ok to overflow onto a third (or more) page, otherwise it should  always reach to the bottom of page 2. 


I have played around with several solutions but nothing works very well. My basic idea has been to make a dedicated print layout with mostly merge fields from the relevant table. 


Sliding up has not worked as needed as;

  1. I still need to set a maximum size and shrink down from it, which I don't really want to do and
  2. there appears to be no way to set a minimum size for a field sliding up.
  3. Fields with no content appear to completely disappear.. 

In summary what I want to do is have a print layout with two boxes that have:

  1. A minimum size
  2. Expand to accommodate large amounts of text


I feel like this should be easy...


Any ideas?





Link to post
Share on other sites

FileMaker does not expand fields. You need to design your print layout to accommodate the field with the most content, and then use the slide up feature shrink the objects up accommodate your print look.


Start by reading this help page on Removing blank spaces

  • Like 1
Link to post
Share on other sites



You need to design your print layout to accommodate the field with the most content, and then use the slide up feature shrink the objects up accommodate your print look.


I have no flexibility in the design. It is based on a paper system and I have zero chance of changing it.


The only way sliding up will work is if there is a way to set a minimum size. That I could work with.


An idea that comes to mind at the moment is to insert non-printing characters or some other nonsense into any field that is not the minimum length but that strikes me as a silly solution and I would love to hear better ideas.

Link to post
Share on other sites



Why don't you let these "boxes" shrink to nothing if necessary, and use another object to limit the sliding of the subsequent object / containing part?


Could you possibly give me an example?


I did toy with some line segments at some point. I "drew" on the sides of the box. But the vertical lines do not shrink up which leaves a box which is always maximum size.

Link to post
Share on other sites
how do I stop the blank space created at the bottom of the document when all the content slides up from being printed?


If I understand correctly, you want to turn on the "Also resize enclosing part" option for all sliding objects.

  • Like 1
Link to post
Share on other sites

This topic is 2007 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By Answers
      We have a layout that has multiple tab panels, I want to add a field in the same place in all the tab panels at once without clicking on each panel. It's probably simple but I can't seem to figure it out.
      Thank you for your help in advance!
    • By Jon David Wardlow Petrie
      Hello My name is Jon Petrie and I am in the same boat as you are and I am trying to setup the samthing as you are with Filemaker To keep track of my bank transactions.
    • By Calvin Tomm
      In list view I want to be able to "grab" an object so I can move the record up or down in the found set. Is there a way to do this? It would be just like how an item on an list in an iPhone gets moved up or down. For example, on a play list in Music, I can change the order of songs to be played.
      Also, I would like to have this capability when I move my solution over to FileMaker Go
    • By amerioca
      Hi everybody,
      I recently amended a db from an old Lynda course, controlling shore excursions for river cruise ships. For my limited expertise (I am still a rookie at the very best) the construction is somewhat complex as there is many vessels, different routes, different charterers and consequently different shore excursion programs and prices. In some cases the shore excursion program of different vessels and operators is similar but not the same and so on.
      I have 7 different tables partly related (pls see graph attached):
      For every journey ::customers and ::trip are assigned a tour code and date (“tour code” is not unique as journeys repeat themselves during the season, “Tour Code” in conjunction with “Date” is unique)
      Every tour operator/vessel has many trips on every journey. All table occurences and fields are uniquely defined by unique id.
      Now I want to create an opening layout reflecting all relevant cruise information such as passenger list from ::customer and ::trip (shore excursions) for the specific journey, as well as other information in text fields.
      But I seem to be unable to get the right relationship and layout setups together. I tried all possible relations and layout setup combination but nothing worked so far.  
      On the same layout I was able to either retrieve the passenger list from ::customer for each journey or the offered shore excursion (trip) list from ::trip  but not both together on one layout.
      What is it, I am doing wrong? Any ideas are appreciated

    • By Gismo12
      Hi All,
      I need to copy one field only from one layout (+- 200 records) and past all those records from that field into another layout.
      I have tried a few commands but does not produce the required result.
      Please could you advise on a script?
  • Who Viewed the Topic

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.