If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Make subform on report not print
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 |
Thread Tools | |
Display Modes | |
|
|