Help - spacing between records of report

[Guest]

Hi
I'm printing Tournament Cards in Access. I have the detail section to be 1 card - and I want 2 cards to print per page.... I have that happening - but I need to increase the amount of space that is printing between the 2 cards (or records). If I simply increase the area below the bottom of the detail section - it pops it off unto the next page because it's trying to add that to the bottom as well... basically I want these to cards equal on the page so I can cut them in half

Of course - it's deadline time - the tournament is tomorrow

Thanks
Sally

 

[Marshall Barton]

I'm printing Tournament Cards in Access. I have the detail section to be 1 card - and I want 2 cards to print per page.... I have that happening - but I need to increase the amount of space that is printing between the 2 cards (or records). If I simply increase the area below the bottom of the detail section - it pops it off unto the next page because it's trying to add that to the bottom as well... basically I want these to cards equal on the page so I can cut them in half.

Of course - it's deadline time - the tournament is tomorrow!

This is a bit strange, but I'll take a shot at it.

Since you didn't specify which version of Access you have,
this idea doesn't use a slightly simpler approach that would
be available in AXP+.

Add a text box named txtFiller below the detail data. Set
the text box's and the detail section's CanGrow and
CanShrink properties to Yes.

Now add code to the detail section's Format event procedure
to adjust the size of the text box by assigning more or less
text to it.

If Me.Top < 4000 Then 'Is detail near top of page?
' Yes, make it grow
Me.txtFiller = vbCrLf & vbCrLf & vbCrLf & vbCrLf _
& vbCrLf & vbCrLf & vbCrLf & vbCrLf
Else
Me.txtFiller = Null 'No, let it shrink
End If

Adjust the number of vbCrLf above to get more or less space
after the first detail on the page. You can also fine tune
the size of the text box by fiddling with its FontSize
property.

For this whacky idea to work, make sure the detail above the
text box is tall enough that you can't get two of them on
the bottom half of the page.