Assuming you're talking about multiple lines within the same detail layout,
I suggest that you place an extra unbound textbox control on the report that
has the height of the space you wish to sometimes have Leave the data
content of this empty, and define it with CanShrink=Yes. Also set the
Detail section to CanShrink=Yes.
If you do nothing else, the space used by the control will appear. In your
VBA, set the control to CanShrink=False (which will make it "No") and then
the space used by the control will appear.
You'll need to set this true/false for each detail record.
Your pageheader is tight against the bottom of your controls in the Detail
section. Slowly move your cursor down across the top border of the
PageHeader. A "Handle" will appear. Drag the top border down a desired
amount so that it is not tpuching the bottom of your controls in the Detail
section.
Your pageheader is tight against the bottom of your controls in the Detail
section. Slowly move your cursor down across the top border of the
PageHeader. A "Handle" will appear. Drag the top border down a desired
amount so that it is not tpuching the bottom of your controls in the Detail
section.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed) www.pcdatasheet.com
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.