That's what I've already done. However, I do allow the field in Sub2 to grow (wrap line). I'm assuming I can do this but still set Can Grow to no on Sub2 within rptMain.
Kirkland? I guess we won't always have Paris. :)
Thanks
Adam
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Adam-
>
> Size the two subreport controls exactly to fit the available space, then set Can
> Grow to no. This will mean that there may be space between the last line of
> sub1 and the first of sub2, but you can't fix the location of Field3 unless you
> do this. Well, you can, but it would require a bunch of complex code to
> calculate and resize sub2 based on the size of sub1.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Kirkland, WA)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of AdamF
> Sent: Wednesday, February 29, 2012 9:41 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Allow a sub-report to grow without pushing lower fields
> down
>
> How do I allow a sub report to grow without pushing fields below it down? The
> report is printed on a pre-printed form, so they have to print in specific
> spots.
>
> There are two sub reports. Sub1 has an undetermined but limited number of lines;
> the lines don't wrap/grow. Sub2 starts immediately below and has up to 3
> lines/records. The lines may wrap/grow. The two reports together have to fit
> within a confined space. That's easy enough. However, there's a field below
> (Field3) that has to print in a specific spot. Because the lines can wrap on
> sub2, it can push that field down.
>
> How do I adjust for that?
>
> Adam
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar