June 9, 200718 yr I have a field that holds the lyrics of a song. When printing/previewing, I want the lyrics to be all on one page. But some of the songs get cut off. Is there a way to split the text into two columns on the same page?
June 10, 200718 yr You could do this with a couple of calculation fields, something like: LeftValues ( text ; n ) for the left column, and: RightValues ( text ; ValueCount ( text ) - n ) for the right column - where n is the number of lines that will fit on your page. You could also split them in half, using Ceiling ( ValueCount ( text ) / 2 ) as your split point.
Create an account or sign in to comment