Help with access subreports

[benjho]

Hi,

I've got a main report that contains around 30 sub reports in the detail section. The only way I can get the reports to fit is to make them around 0.1 cm high, so it looks just like a lot of lines.

Is there some simple way that I can add a control or something to the detail section, and use vba to populate the control.

Any advice would be appreciated.

 

[Pat Hartman]

Are you saying that the report doesn't print correctly or that you have trouble working with it in design view. If the problem is the former, set the can grow and can shrink properties to Yes for all the controls and report sections.

 

[benjho]

The report doesn't print correctly with varying gaps between sub reports. I've already set the grow and shrink controls to yes for all the controls and sections. In order to fit all the sub reports onto the main report, I've had to set the height of all of the sub reports to 0.1 cm, hence the mess.

 

[Pat Hartman]

If any controls overlap, they won't shrink.

Why do you need so many subreports? Perhaps the report needs to be redesigned.

 

[Mike375]

I am wondering if the 30 subreports could be replaced by the correct grouping and sorting?

 

[benjho]

The database is a single table of 70 record fields with 65 different transaction types populating on average 7 different record fields. Each transaction type has its own report as the layout varies significantly in terms of fields used and associated content.
Because of the varying report structure sorting and grouping isn't a suitable option.
Unfortunately I'm required to report monthly on each transaction by transaction type, hence the use of sub reports.