Can Grow Problem

  • Thread starter Thread starter DDJ
  • Start date Start date
D

DDJ

In the process of creating a report for our users that would occasionally
need to accomodate large text fields in the Detail Section of the report, we
now cannot get the Detail Section to shrink unless we set the Detail
section's Can Grow property to "No". This is true even if all of the
controls in the Detail section have both the Can Grow and Can Shrink
properties set to "No" (or if Can Grow is set to "No" and Can Shrink is set
to "Yes").

When the Detail section Can Grow property is set to "Yes", we get this large
blank space beneath every detail record, ending up with just two records per
page. Also note that although the report contains 3 grouping levels, all of
these have the Visible property set to "No" for purposes of this test. We
have also verified that there are no hidden controls lurking in the Detail
section that might cause this to happen.

Can anyone suggest a solution here, or maybe a reference to some online info
in this regard?

Thanks in advance!

Dan
 
DDJ said:
In the process of creating a report for our users that would occasionally
need to accomodate large text fields in the Detail Section of the report, we
now cannot get the Detail Section to shrink unless we set the Detail
section's Can Grow property to "No". This is true even if all of the
controls in the Detail section have both the Can Grow and Can Shrink
properties set to "No" (or if Can Grow is set to "No" and Can Shrink is set
to "Yes").

When the Detail section Can Grow property is set to "Yes", we get this large
blank space beneath every detail record, ending up with just two records per
page. Also note that although the report contains 3 grouping levels, all of
these have the Visible property set to "No" for purposes of this test. We
have also verified that there are no hidden controls lurking in the Detail
section that might cause this to happen.
Click to expand...


That sounds pretty bizzare. Check the data to make sure
that the text field(s?) do not have a bunch of blanks or new
lines at the end.

Don't forget that a text box's CanShrink property must be
set to Yes to allow the control to shrink AND the section's
CanShrink property must also be set to Yes to allow the
section to shrink. Similarly for CanGrow.
 
Thanks for your response Marshall.

It was pretty bizzare alright, and I think I have it figured out. I was
manipulating the fields in code, and somehow or another was setting the
control source for one of the textboxes in the Detail in such a manner that
it made Access go nuts. Can't quite put my finger on the exact cause yet,
but know that if I avoid changing the control source, the problem is
eliminated. This should get me to where I want to go, eventually!

Again, thanks for your feedback!

Dan
 
Back
Top