FoxPro looks at the space defined for the detail band to determine whether there is room to print or not. It doesn't bother to evaluate all the print when logic for figuring out the remaining space.
You can do a couple of things. One is what you suggested where you stack the fields on top of each other. To help with the maintenace nightmare, before you stack them, select all the fields for a particular section and then select Format | Group from the menu. This will tie all these fields together so you can move them as one field. Do the same for the other sections. If you ever need to edit them, you have to Ungroup them first.
Another thing you can do is create a dummy data group with an expression of RECNO(). This creates a Data Group Header and a Data Group Footer for each detail band. That means you can put one set of data in the Group Header, one in the Detail band, and one in the Group Footer. If you need more than 3, just create another Data Group with the same expression and you'll get 2 more bands to play with. You can have up to 20 data groups defined!!
Cathy
>We have a detail band that's 3.5 inches long. In the detail band we basicly have 3 sections but only one section prints at a time. So about 1 inch will print per line. The rest have remove line if blank and print whens. The problem is that when it goes to the next page FoxPro leafes about 2.5 inches at the bottom. I'm assuming its allocating 3.5 inches for the detail and then says I'm at the bottom of the page and it ejects when it could print more information at the bottom. The only other option that I can think of is to stack the fields on the report but what a maintenance nightmare.
>
>Is there someother way or is there a way to tell FoxPro to print all the way down to the bottom of the page?
>
>Thanks in advance.