Access 97. Reports can have data in columns. But if the report is used as a sub-report the column feature is lost. Any way round this problem please? Something like "flowing textboxes" in a dtp program?
Thanks for any help.

Clive Astley

__________________
Clive Astley

I guess I do not completly understand what you mean by "Columns". The report should show the same as a subreport.
Could you please elaborate on your definition of columns?



Sal

Thanks for replying Sal. By columns I mean where a narrow column of data can "flow" into two columns on the same page; eg:

Record One Record Four
Record Two Record Five
Record Three Record Six

In a report, this can be achieved from the columns command in Page Setup. But the property is lost when the report is used as a sub-report. This is correct according to online help.

What I am looking for is a workaround to produce the same effect.

Clive

Clive Astley

Got me there. I remember a report doing this to me once.

Try to re-create it with the wizard and select the actual formating during the creation. Access seems to remember the formating done with the wizard more.



Sal