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

Report and subreports trouble

100+
P: 157
Hello!

I have just made a report based on 3 subreports named 1,2 and 3.

http://bayimg.com/AAgkpaABi

The thing is i cant stop the user from filling in 20 lines in Report1 and because of that the Report1 in ReportMain overlaps Report2.

How can i make RaportMain adjust the top position of Report2 by how large Report1 is?

I tried some VBA code but i get run time error 2135, the property is read only, even when i have opened ReportMain in forming mode.

Any tips?
Attached Images
 
Aug 31 '07 #1
Share this Question
Share on Google+
3 Replies


JConsulting
Expert 100+
P: 603
make the subreports physically less tall. Make sure they don't touch one another. Set the cangrow property to yes. Access will take care of the rest.
J
Sep 1 '07 #2

100+
P: 157
Thank YOU!!!!!!!

:-)
Sep 1 '07 #3

JConsulting
Expert 100+
P: 603
Thank YOU!!!!!!!

:-)
Anytime :)
Happy to help.
J
Sep 1 '07 #4

Post your reply

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