Add blank rows to detail section

S

ScottA

I am generating a report which will be printed and used
for paper-based documentation. All of the data on the
report is printed in a header section, while the detail
section of the report will be filled in offline (on paper).

I would like the report to generate a variable number of
blank lines based on a value returned by the query. So if
the value in the field is three, I would like there to be
three blank lines in the Detail section.

Anybody know how to make this happen?

Thanks,

Scott A
 
M

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In Acc XP there is a Print method in the Report object. So in the
report's Detail_Print event procedure you could use that to insert the
blank lines. E.g.:

dim i as integer
for i = 1 to rs!SkipLines
Me.Print ""
next i

See the Access Help article "Print Method" for more info.


MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQD+sD4echKqOuFEgEQI0cACfcoSZpvdpGKZ/Sf71oXZ5KAO9EqUAnR3q
u8ohJxvLPocghIBjurdernEi
=ab2O
-----END PGP SIGNATURE-----
 
Top