Concatenation subreports in report

Concatenation subreports in report - formatting question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susy - 02 Jan 2007 23:18 GMT

I've followed instructions in the Microsoft Knowledge Base to create
subreports with concatenated fields that then plop the results into my main
report. It works beautifully but with one small problem. No matter where I
place the subreports - which are set to 0" high and 2" wide, there is quite a
large gap of white space. Since this report needs to appear seamless, I need
to get rid of the white space (the gap). Any idea what is causing this? I've
placed the subreports at the beginning, end, added different headers and
footers to try them in - but I always get that gap. Please help if you can.
(Using Windows XP, Access 2000).
Thanks a lot.

Reply to this Message

Allen Browne - 03 Jan 2007 00:49 GMT

1. In report design view, is there white space above or below the subreport
in the section where you placed it? If so, close the space up.

2. Right-click the edge of the subreport control, and choose Properties.
On the Format tab of the Properties sheet, set Can Grow and Can Shrink to
Yes. The subreport can now shrink and grow as needed.

3. If that doesn't solve the problem, check that the Can Shrink property of
the (Detail?) Section is also set to Yes.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I've followed instructions in the Microsoft Knowledge Base to create
> subreports with concatenated fields that then plop the results into my
[quoted text clipped - 11 lines]
> (Using Windows XP, Access 2000).
> Thanks a lot.

Reply to this Message