Create an empty space within a report

[SnowFox]

I have a report that I need to create that will print on a very specific
paper. The paper has 2 columns, and in order for the information to fit
properly within the white space of the paper, I need to have a break of 1/2
inch every 2 inches.

The report needs to go down and then across.

I have Access 07, and really need help with this problem.

 

[Marshall Barton]

I have a report that I need to create that will print on a very specific
paper. The paper has 2 columns, and in order for the information to fit
properly within the white space of the paper, I need to have a break of 1/2
inch every 2 inches.

The report needs to go down and then across.

I have Access 07, and really need help with this problem.

I really need to know more about the report's detail
section:

Can it grow? If it can, I don't think there is a way to do
it.

Are these 2 in. boundaries every 2 in. from the top of the
page? Or are they relative to something else?

If it can not grow, then try this kind of trickery.
Add a module level variable to the top of the report's
module:

Private lngHgt As Long

Then set the variable in the report's Open event procedure:

lngHgt = Me.Section(0).Height

Then, I think code somthing like this in the detail
section's Format event will be close to what you need:

If (Me.Top + 2 * lngHgt) Mod 2880 < lngHgt Then
Me.Section(0).Height = lngHgt + 2880 + 720 _
- ((Me.Top + lngHgt) Mod 2880)
Else
Me.Section(0).Height = lngHgt
End If

 

[SnowFox]

Marshall
Thanks for the reply.

The report was set to allow grow, so I went through and changed everything
so it would not grow.

Then I tried your trick. Maybe I don't know what I'm doing, but in Access
07 it does not show Module like it did in the past. I found ad module in
visual basic. So I tried your trick there. It didn't work.

I went to help, and found out that I needed to set it up as an event in the
properties section. It didn't work there either.

It could be that I was doing it wrong, or I just don't know what I'm doing.

Snow Fox