Subreport columns no longer work correctly after upgrading from Access95 to 2003

[Andrew Simpson]

We have just upgraded from Win98SE/Office 95 to XP/Office 2003.

Several of our reports which use columns in a sub-report no longer
worked after doing this.

After some fiddling with the layouts, I managed to fix most of them,
however the Despatch report still does not work.

The report shows a single despatch split into one or more sections.

Each section has a header and footer.

Within the Detail section is a sub-report with columns which shows the
pallet contents of the despatch.

Despatch Header

Section Header

Details
Sub-report
[
Pallet 1 Pallet 2 Pallet 3 etc.
Box 1, 25kg Box 1, 27kg Box 1, 22kg
Box 2, 25kg Box 2, 27kg Box 2, 22kg
Box 3, 24kg Box 3, 27kg Box 3, 22kg
Box 4, 23kg Box 4, 27kg Box 4, 22kg
Box 5, 25kg Box 5, 27kg Box 5, 22kg
Box 6, 25kg Box 6, 27kg Box 6, 22kg
]

Section Footer

Despatch Footer


The problem:
The sub-report is 7 columns wide. Originally if there were more than 7
pallets in a section, the report would produce the rest on the next
page. Now however they are just not printed at all.

Eg. a despatch with 10 pallets in a section would show pallets 1-7 on
first page and 8-10 on second page. Now pallets 8-10 just disappear.

Any help solving this is greatly appreciated.

TIA,

Andrew