By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,045 Members | 1,367 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,045 IT Pros & Developers. It's quick & easy.

Access sub report to remain at a fixed length

100+
P: 418
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.
Jun 5 '14 #1

✓ answered by 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?

Share this Question
Share on Google+
7 Replies


Seth Schrock
Expert 2.5K+
P: 2,951
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?
Jun 5 '14 #2

100+
P: 418
@Seth Schrock
I need its length set. How do I do this once i set the Can grow/shrink to false on a subreport?
Jun 5 '14 #3

Seth Schrock
Expert 2.5K+
P: 2,951
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.
Jun 5 '14 #4

100+
P: 418
@Seth Schrock
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.
Jun 5 '14 #5

Seth Schrock
Expert 2.5K+
P: 2,951
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.
Jun 5 '14 #6

NeoPa
Expert Mod 15k+
P: 31,769
Long time no see Mareena. Hi.

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

100+
P: 418
@Seth Schrock
Worked great. Thank you for your time.
Jun 9 '14 #8

Post your reply

Sign in to post your reply or Sign up for a free account.