Can't control subreport spacing

[bonnerm]

Hi all,

I have a main report with about 8 subreports in the detail section. Some subreports are invalid depending on ProductType (the grouping level above). I have code in the On Format event for the detail section of the main report to mark certain subreports not visible. So for example, for a particular ProductType only the 4th subreport down might display (if you visualize the subreports stacked in a neat pile one after another). I've set "can shrink" just about everywhere with no success and I'm beginning to wonder if Access is able to reclaim space not needed by an invisible sub report?

Thanks in advance .. Mark

[June7]

Encountered this topic before and as far as I know, the subreport will still occupy space.

Might be able to programmatically set the Visibility and Top properties of the subreports. So, if no data, cause the following subreports to 'move' up. Wild speculation here, never attempted.

[bonnerm]

Thanks - your wild speculation wasn't so wild as you thought - seems to work. I have to put a lot of code in to calculate the position for the top of the next sub report (depending on what has been print previewed earlier) but it has the required effect. Thanks again .. Mark