Make subform on report not print

I have approx 3 subforms on my report (I did not build it). It is fired from
a main form's otion box. If the option box is false, the COMMENT SECTION on
the report (subform) willnot be visible. If it is True then it will be
visible. Question: How do I get that subform not to Print or be Viewed? It
shows a blank page either a full page, 1/2 page quarter page etc. HELP!

On Fri, 20 Jul 2007 10:56:06 -0700, TKM
wrote:

I have approx 3 subforms on my report (I did not build it). It is fired from
a main form's otion box. If the option box is false, the COMMENT SECTION on
the report (subform) willnot be visible. If it is True then it will be
visible. Question: How do I get that subform not to Print or be Viewed? It
shows a blank page either a full page, 1/2 page quarter page etc. HELP!

Look at the Can Shrink property of the control holding that subform.
It should be set to Yes.

Can Shrink will not work if there are controls to the right or left of
the shrinking control.

Also, Can Shrink will not work if there are any overlapping controls
on the report. Sometimes crowded reports have controls that overlap
just a tiny bit, so that you don't notice.

BTW, here's a trick to make sure that adjacent controls are touching
but not overlapping: Select two or more adjacent controls. Click
Format, Horizontal Spacing (or Vertical Spacing), Decrease.

Access will not decrease spacing to less than zero. It will actually
*increase* the spacing to exactly zero, making the controls touch each
other perfectly without overlapping.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com