Skip to Content
0
Dec 13, 2011 at 01:47 PM

Checking header on each page for memo field

34 Views

Hi,

I have a report which has several details sections (4). In each detail section I have a title field and a content field. The content field is a memo fields and my problem is when the memo field goes on to another page it does not show the header.

I read somewhere about having the memo fields in sub reports and then in the subreport put a group in and the header in the group header and set repeat at top of every page to true. I tried this but my table is always empty because in vb code I create a memory recordset and set that as the recordsource. When I try to preview the report I get and error:-

This group section cannot be printed because its condition field is nonexistent or invalid.

I am getting I get this error because I have changed the datasource of my main report.

Is there another way to solve my issue?

Thanks for any help,

Jiggy!