Jump to content

Printing large text fields & odd field behavior

Recommended Posts


I have a musical performance management solution (Gigs) which contains several tables including Gigs (performance dates, times, etc.), Songbook (information about an actual song performed), gigs_PERFORMANCES which joins the two, and other related tables.

Two fields in the Songbook table are large text fields (Lyrics and Chart) which are the lyrics for a song and the guitar/piano chart for the song, respectively. Both can be long - particularly lyrics. Also a flag field indicating the presence of data in either field exists in the Songbook table.


The objective is to print a lyrics book or charts book for a Gig  or create a PDF of same (portal to gigs_PERFORMANCES provides the list).


Everything works fairly well at this point. In my print layout, I have Lyrics formatted as very, very large field (28" height) with shrinking set. The layout is sized to the same length so that part I went through several iterations to get the printout to paginate correctly.

I now have one very strange issue and a pie-in-the-sky question.


There's a very weird issue which I've tested in several different Gigs records. On ONE particular Gig, the last two record's lyrics are combined. I don't know how to show this except to share this PDF screen capture of the last two lines of the song "Home" which is followed by the entire set of lyrics for the song "At Last."

"At Last" should start a new page with a new updated header and page number. All previous pages are perfect.
I have absolutely no idea where to start to troubleshoot this issue.



In the case of these fields, charts in particular, you can see that chords are displayed on the line above the lyric the go with. Thus, if possible, I'd like to always keep the lines together (i.e., no page break). This is also the case with lyrics where one might want a particular verse or phrase to always remain together to avoid breaks in illogical places in the lyric. 

Does anyone know of a way to "keep" text within a field together? I think it doesn't exist, but thought I would ask.


Link to post
Share on other sites

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 AndreasvanHaren
      How can I count the amount of lines in a text field? And is there a way to get a live update of the line count while typing in the field without it slowing down or interrupting the typing? 
    • By qpywsqp
      Dear All,
      I would like seek for your help on my current situation. I had PC laptop running Filemaker Pro 15 with a Duplex printer.
      In my solution i had create 21, first layout will be consist of a field and print button. As of the rest of 20 layouts which i had set the field in different location ( randomly ).
      My intention is to have duplex printing all the 20 layouts in one single print job. 

      How can do that with one single button?
      Thank you in advance. 
    • By Quito
      Charles Ross (Chuck) posted the following script in 2010 to split the contents of a text field into text chunks, using the last period (within a period count) as text chunk separator:
          MaxString = Left( String; 100 );
      // Get the first 100 characters of the original string.
          PeriodCount = PatternCount( MaxString; "." );
      // Find out how many periods are in the substring.
          PeriodPos = Position( PeriodCount; "."; 1; PeriodCount );
      // Get the position of the last period.
          Substring = Left( MaxString; PeriodPos )
      I've only been able to get the first line to work with a given number of characters:
      Left ( String ; 1880 )
      When I add the rest of the script there is no error message, yet nothing is recovered from the String.
      The second problem I have is: As the remaining text will not necessarily start at 1880, how do I calculate the recovery of the remaining text after the first text chunk is collected?
      Thanks very much beforehand,
    • By dkey
      I am trying to use FMPA13 on my 13 MacBookPro to read a text field and time it inserting the resulting time in a specific field
      I import the text files from a folder. Each text file has a dffret lenght,
      My screen is small and certain pages are too large to appear in the text field a I created
      Is there a way to force the import of a single text file splitting if necessary in a double or even triple column while keeping it with the same field name?
    • By Dr.Hamed
      I have a textbook composed of chapters. The book was simply entered as separate sentences in text field, and chapter titles in another text field.   Chapter Title                  Sentence ABC                                     aaba ABC                                     abac ABC                                     efgdf ABB                                     bdc ABB                                     cdfegdf . . .   What I would like is that when I search for a chapter title, to have the result of sentences summed up in a field and separated by serial numbers starting from 1   For example: Searching the above data for the title:   ABC should show the output in a field as:    aaba (1) abac (2) efgdf (3)   Of course chapters have variable numbers of sentences, so the count has to stop with the last sentence.  
      I really appreciate your help.
  • Create New...

Important Information

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