can grow settings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M G Henry - 07 Dec 2006 07:08 GMT

I have a report that potentially could hold up to 12 pages of material,
however as the details are filled in on the form, for the fields that
do not have a vaule contained in them, I do not want anything to print,
but I also want the next section to butt up to the current section, so
that the minimal length of the report would be 2 pages ( header page
and 1 page of grouping and / or detail as the case may be )

>From what I have read, the key lies in the setting of the can grow to

YES to allow it to fit to size. That setting is on the various
sections, but what about the individual fields within the section, how
is this handled ??

M G Henry

Reply to this Message

Marshall Barton - 07 Dec 2006 14:33 GMT

>I have a report that potentially could hold up to 12 pages of material,
>however as the details are filled in on the form, for the fields that
[quoted text clipped - 7 lines]
>sections, but what about the individual fields within the section, how
>is this handled ??

Several controls have the CanGrow property too. You need to
set each appropriate text box and/or subreport control's
CanGrow proerty before anything can happen. Set the
section's property if you want the section to grow too.

Don't forget about using CanShrink so the controls can be
made shorter when they have less data than the design allows
for. Text boxes that have a Null value, a Zero Length
String value ( "" ) or are invisible will shrink to nothing.

Signature

Marsh
MVP [MS Access]

Reply to this Message