ACCESS 2007 subreport issues

G

Guest

For some reason my subreports are not growing and shrinking like they did in
ACCESS 2003. All the "can grow" and "can shrink" are set to YES for each
subreport. I then place them on the main report. Some appear to grow and
shrink while others overlap the next subreport. Does anyone know of a
different setting that may need to be checked? I've gone back to reports I
created in ACCESS 2003 and double checked them but can't seem to find any
clues.
 
G

Guest

I'd check the "can grow" settings at all levels, including / especially the
detail section. (I.E. not just the subreport or controls) If I recall,
the default setting foor '97 for the detail section was "NO" and it's "Yes"
for 2003.
 
G

Guest

Okay - I've checked and changed everything including the detail section on
the main and subreports. It still isn't working.

Here is what my report looks like:
I have three subreports across the page (landscape) - the report will work
fine.
Then I add a second row of subreports under the first row and they truncate.
I can view the subreports outside of the main report and they look fine.

I have one old report I created in 2003 that has 22 subreports and they all
grow and shrink with no problem. I've got to roll this database out before
the quarter starts and I'm starting to panic. What good is a database
without the reports?

Thank you so much for your response.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top