Issues in Building a Report with multiple subforms

[RobH]

I need to make a quotation report which will need to bring in different subForms/Reports. The problem I have is that if the content of the subform is longer that the area allocated it truncates the rest of the SubReport, or if its shorter it leaves a whopping great white space between Sub components.

I have....

tbl-QuoteDetails - this holds the details for the customer - Quote#, name, address etc
tbl-Quoteparts - this holds the parts that were sold to the Customer - this has a field "type" which seperates the type of part into categories.
tbl-Installation - this holds the Installation details for each Part category in tbl-QuoteParts

As there are different fields used for each category, and the order of each part category in interspersed with the Installion detail, I need to use a different Subform for each category in each of the tbl-QuoteParts & tbl-Installation

I need to be able to have a quotation show all of the records for all of the SubForms without truncation and without huge spaces between subForms/Reports

Any thoughts? Thanks.

[mlcampeau]

Go to design view, click on your subform and go to properties. Under the Format tab, change Can Grow to Yes and Can Shrink to Yes.

[RobH]

Go to design view, click on your subform and go to properties. Under the Format tab, change Can Grow to Yes and Can Shrink to Yes.

Thank You!!! Thank You....

[mlcampeau]

Thank You!!! Thank You....

Your welcome. Good luck with the rest of your project!