View Full Version : Data extending over several pages


KennyM
09-12-2006, 06:06 PM
Hi,

I have a report with what is effectively columns of data, with a grid drawn around it to make it into a table. I have one text box that is set on the 'onformat event' by a function which builds a string based on some criteria. This string in some instances due to its size should span several pages in its column. However the report is only showing the first page worth of information for these occurences then continuing on the next page with next record. I have tried various combinations of the 'grp keep together' setting of the report and the 'keep together' setting of the detail but with no joy. Does anybody have any ideas?

Thanks

Kenny

Ziggy1
09-14-2006, 07:42 PM
what sections of the report are your controls in, explain the grouping

RexesOperator
09-17-2006, 04:25 PM
I forget where I came across this example, but would this link help?

http://support.microsoft.com/default.aspx?scid=kb;en-us;231808&Product=acc

KennyM
09-17-2006, 08:41 PM
what sections of the report are your controls in, explain the grouping

The controls are in the detail section.

KennyM
09-17-2006, 09:02 PM
I forget where I came across this example, but would this link help?

http://support.microsoft.com/default.aspx?scid=kb;en-us;231808&Product=acc

Thanks, I've checked it out but it doesn't really help. The problem I have is that text is being truncated when it spans multiple pages to the first page.