Can No. of report pages be determined by amount of text in text Field?
I am new to FMP and have inherited a FMP11 3000 record research database that prints a 1 page report for each record. The last field of the record is a text field called "Notes" that may contain say 60 words or 600 words. What i am unable to do is to get FMP to print a single page when there is a small amount of text in Notes but print on two pages when there is a lot of text. At moment I am forced to make the report form 2 pages in size such that all records print on 2 pages, regardless of amount of text in "Notes", which is far from eco friendly. I have looked at sliding fields but not really got anywhere with them.I must be missing the obvious but can it be done simply and if so how?
Thanks in advance for your advice.