Report Margins

[Mark Zec]

Hello, all...

I'm working on a report in Access 2000, and have a report
that includes a second report as a subreport. Any margin
changes I make to the subreport are overridden by the
margins settings of the parent. Is there a way to have
different margins for different pages?

The problem is that the first page of the report requires
little "tick" marks at the bottom of the page...the entire
printout is being fed through a machine for automated
folding and stuffing of envelopes. The printing on the
remaining pages is unfortunately triggering the
folding/stuffing at the wrong time. Raising the margins on
the main report moves the data in the subreport up higher,
but also raises the tick marks higher as well. The result
is that the tick marks are then too high, so the automatic
folding/stuffing doesn't occur at all.

Thanks in advance for any help!

Mark

 

[Duane Hookom]

If you want tick marks to appear at the same place and only on the first
page of the report, I would use code in the On Page event of the report. The
following code draws four tick marks on the first page only.

Private Sub Report_Page()
Dim intLineLength As Integer
intLineLength = 1440 / 4 '.25 inches
Me.ForeColor = vbRed 'red for effect
If Page = 1 Then
'draw ticks a top
Me.Line (0, 0)-Step(intLineLength, 0)
Me.Line (Me.Width - intLineLength, 0) _
-Step(intLineLength, 0)
'draw ticks 9.5" down
Me.Line (0, 13680)-Step(intLineLength, 0)
Me.Line (Me.Width - intLineLength, 13680) _
-Step(intLineLength, 0)
End If
End Sub

 

[Mark Zec]

That may be exactly what I was looking for. Thanks!

 

[Duane Hookom]

Can't you just leave some white space on the left or right of the main
report or subreport?