Fixed Size for Detail Section

[bigdavidt]

Good evening. I am working on an Access 97 report that requires that the Detail section be a fixed size irregardless of how many records it displays. What is the best way to do this? Can anybody point me to an example of how this is done?

Thank you in advance.

 

[dhookom]

Consider creating a subreport on a main report and set the size of the subreport and don't allow it to shrink or grow.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[bigdavidt]

I tried creating the subreport this morning. It worked OK on some pages, but in some other cases I got a group of detail entries, and then a duplicate group of detail entries. Very puzzling.

I also tried to programmatically determine the height of the Detail band using Visual Basic settings. My code worked, but the spacing was repeated for each record. I have worked out how high the detail band should be. If I could get the number of records the particular group has, I could use that to change the height of the band (and thus the spacing of records within the band) so everything stays in the one area without spilling onto another page. But how do I get the count for records in a group and convey it to any VBA I code into the report? Anybody have any ideas?

 

[dhookom]

Your main report should not include the same level of detail as your subreport. You can switch your main report's record source to a totals query and count the number of records that would normally appear in your subreport.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]