Suggestion on printing large section of text

[hyuan]

I have a report with 3 pages of text attachments at the end of the report. Right now I'm using a series of labels to display the text (each label can hold a max of 255 characters). In order to make the labels look contineous, the labels has to overlap one another. Is there a better way to display a large section of text?

Thanks in advance for any suggestions.

 

[scriverb]

I have used a Parameter table for situations like this. I create a table in the application that holds database parameters and "TEXT DATA". In this situation I would create a table and call it tblDBParameters. Create a field called LINK(Number, Long Integer). Create a second field called TextData(Memo). After saving the table enter a one(1) in the LINK field and type your long text data in the memo field. You might want to create a small temporary form bound to this table to enter the data for the memo field. There should only be one record in this table.

Now create a query for your report. Include the table tblDBParameters in the design. Also include the TextData field as a column. No links are necessary. Now this memo data is available in your report to be printed at anytime. It is a column of each detail record. It sounds as if you want to print it at the end of the report. Just create a Text control and set the property Can Grow to Yes. You do not have to make it larger than one horizontal lines worth. The control will grow with the amount of data entered.

Let me know how this works for you. Bob Scriver