Help resizing Detail section of a report

[Cineno]

Hello, I've entered a lot of stuff in the Detail section of a report. But, I still need to enter more. Before, when I needed more space, I would just drag the footer to a lower position and it would be fine.

But now it's not letting me. I went to the properties of the Detail section and tried to change the height to 25" but it said that was too big. I've tried other numbers, and the most it will let me go to is 22". Does anyone know what's going on, and how I change this? Any help is very appreciated, since I still have a lot more to enter.

 

[traingamer]

You've hit the height limit. Try breaking the report into subreports or rethinking why you need that much data on a single report.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Remou]

For reference, this thread is a continuation of:
Help resizing Detail section of a report
thread702-1257958

 

[Cineno]

Thanks for all the help so far. But, I'm having trouble adding a section. My book tells me to go to the Sorting and Grouping button on the toolbar. So I did that and choose to group by ascending, even though I'm not sure what that's gonna do. When I try to look at it in print view, a message box pops up and askes for the new setion's parameter value.

I have no idea what this is. Did I add the section correctly? What is the right way to add a section?

 

[dhookom]

You open the Sorting and Grouping dialog and select your primary key field (unique value in report record source) as the [blue]Field/Expression[/blue]. Then set the [blue]Group Header[/blue] to Yes. This will open a new section in your report that can be used as an extension to the top of your detail section.

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]