Columns overrun set height

[zapzip]

Hello-
I am stuck on a reort with a subreport that has 3 columns (columns set at 2" width and 2" Height. The report displays the subreport with columns with height necessary to accomodate the number of text box records in the recordset.

Any ideas how to fix this? I have gone around & round with no solution. Thanks

Change. Remember. Enjoy. Do it often. Dotcom

 

[lameid]

So you want to change your columns to go accross then down?

Or does the main report have the columns?

 

[zapzip]

If I set the report to down & then across a single long column is printed. It is now set at across then down. Three columns are printed however they are longer than the specified column height of 2 inch (as set up under File> Pge setup @ column tab).

Any ideas?- apprcieated

Change. Remember. Enjoy. Do it often. Dotcom

 

[dhookom]

I don't understand your question/problem. I have no idea what the Height property in Columns is used for. Normally the height of the detail section will times the number of records divided by the number of columns will dictate the height of the subreport control on the main report.

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]

 

[zapzip]

Your explanation "normal" behavior pointed the way to a solution.
The main problem wass that in the main report the Subreport that contains 3 columns would not “snake” to the next column. The solution was changing the Can Grow property to No.

I thought that the Page Set up Column Size Height property set this.

Thanks for pointing the way. The problem is solved.


Change. Remember. Enjoy. Do it often. Dotcom