Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Printing large text fields & odd field behavior

Featured Replies

BACKGROUND

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.

GOAL

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).

SITUATION

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.

VERY STRANGE ISSUE

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.

image

PIE-IN-THE-SKY

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.

image
 

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.