Report Can Grow causing Blank Pages

[scott]

I have a report with a text box control that uses a memo data type. The text
box is located well inside the page margins and has its "Can Grow" property
set to "Yes". Each page on the report contains one record from the database.

The strange behavior I'm getting is after some pages, I get a blank page
(except the page header, i.e. no record fields or labels). It's almost like
the record is blank for that page. I've seen this before when some controls
get too close to the margins, but this is not the case. I should note that
even on records that contain a lot of text in the memo field, the text box
control is still several inches away from the bottom and right page margins.

If I set the "Can Grow" property to no, the blank pages disappear and the
report is perfect.

This problem occurs in both Access 2003 and 2007.

Any ideas?

 

[Marshall Barton]

I have a report with a text box control that uses a memo data type. The text
box is located well inside the page margins and has its "Can Grow" property
set to "Yes". Each page on the report contains one record from the database.

The strange behavior I'm getting is after some pages, I get a blank page
(except the page header, i.e. no record fields or labels). It's almost like
the record is blank for that page. I've seen this before when some controls
get too close to the margins, but this is not the case. I should note that
even on records that contain a lot of text in the memo field, the text box
control is still several inches away from the bottom and right page margins.

If I set the "Can Grow" property to no, the blank pages disappear and the
report is perfect.

This problem occurs in both Access 2003 and 2007.

That might happen if the memo field somhow has a bunch of
newlines at the end of the text. Another possible cause is
if there is blank space between the bottom of the text box
and the end of the section.

 

[scott]

Can you expand on your "blank space between the bottom of the text box and
the end of the section" reason?

I thought the "Can Grow" property was made to allow a text box grow. As far
as I can tell, the pages prior to the blank page have records that don't
have very long data to fit inside the text box in question (i.e. the
previous record's textbox shouldn't be over-flowing due to the data length
of the memo data).

 

[Marshall Barton]

Can you expand on your "blank space between the bottom of the text box and
the end of the section" reason?

I thought the "Can Grow" property was made to allow a text box grow. As far
as I can tell, the pages prior to the blank page have records that don't
have very long data to fit inside the text box in question (i.e. the
previous record's textbox shouldn't be over-flowing due to the data length
of the memo data).

If a text box grows and if the section's CanGrow property is
also set to Yes (automatic when you set a text box's CanGrow
property to Yes), then anything below the text box remains
after the section grows. When the section's CanGrow is set
to No, then the text box's growth pushes the stuff below it
off the bottom of the section.

The blank space I'm talking about is below the bottom of the
text box and the bar at the top of the next section. This
space is part of the section and will be displayed in its
entirety when the section grows (regardless of what the text
box does).

To remove that blank space, drag the bottom of the section
up over the text box and let it go. Access will move it
back down just far enough so that all controls in the
section can be displayed.