Access sub report to remain at a fixed length

[MNNovice]

I would like my subreport to print/view at a maximum of 20 lines data. If i have only 1 line data I would like the report to show 1 line data and 19 blank lines.

Right now, it's shriking or expanding based on data. If I have 5 lines, it shows 5 lines. How do I make it to show 5 lines data and 15 blank lines.

Any help would be nice. Thanks.

[Seth Schrock]

Make sure that the Can Grow and Can Shrink properties are set to false on the subreport. This will make it keep its size, however it won't add blank lines. Do you specifically need blank lines, or do you just needs its length set?

[MNNovice]

Make sure that the Can Grow and Can Shrink properties are set to false on the subreport. This will make it keep its size, however it won't add blank lines. Do you specifically need blank lines, or do you just needs its length set?

I need its length set. How do I do this once i set the Can grow/shrink to false on a subreport?

[Seth Schrock]

You can either drag the sizing handle to fit it where you want it, or you can change the height property. Either way, it is a guess and you will just have to play with it until it is the size you want it.

[MNNovice]

You can either drag the sizing handle to fit it where you want it, or you can change the height property. Either way, it is a guess and you will just have to play with it until it is the size you want it.

I actually tried this. But it didn't work. Perhaps because I didn't have the can shrink can grow set it to false. I don't know how to do this. When I look at the property screen under format tabs I only see "Auto Resize" Yes/No. Am I looking at the wrong place? Couldn't find an optrion for true/false.. Thanks for your time.

[Seth Schrock]

You need to have the subreport control highlighted instead the subreport itself. Subreports/subforms are actually contained within a subreport/subform control. So if you click in a gray area outside the report and then click on the subreport, you should see on your property sheet that the selection type is Subform/Subreport. Once you see this, then you should see the Can Grow/Shrink properties almost at the bottom of the format tab.

[NeoPa]

Long time no see Mareena. Hi.

Don't forget to set post #2 as Best Answer when you find it works for you :-)

[MNNovice]

You need to have the subreport control highlighted instead the subreport itself. Subreports/subforms are actually contained within a subreport/subform control. So if you click in a gray area outside the report and then click on the subreport, you should see on your property sheet that the selection type is Subform/Subreport. Once you see this, then you should see the Can Grow/Shrink properties almost at the bottom of the format tab.

Worked great. Thank you for your time.