Adding a blank line to a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to add a blank line after every fifth line is printed on my report. The report is a price list with small print and everyone is asking for some sort of break between lines to make it easier to trace from left to right.

Thanks for your help
 
This works:
First, add a cumulative counter to the report in the
section where the data you want to break occurs. Set its
Control Source =1. Make it a Running Sum Over Group. Make
the box invisible, if you don't want a line counter to
show up in the report.
Next, add a bound text box to the same section.
Position it directly under the line you want to break.
Set it's height=0 and CanGrow= Yes. In the box type =IIf
([text1] Mod 5=0," ",""), where [text1] is the name of the
counter box you install in the first step. Note the
first " "contains a single space, the second is closed.
When you runt the report, the bound box stays closed
until the 5th rep, when it opens up to print a blank space
(" "). Obviously, you can control how often the break
occurs by changing the mod statement.

Hope this helps.

-----Original Message-----
I would like to add a blank line after every fifth line
is printed on my report. The report is a price list with
small print and everyone is asking for some sort of break
between lines to make it easier to trace from left to
right.
 
Back
Top