Add blank rows to detail section

  • Thread starter Thread starter ScottA
  • Start date Start date
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
 
-----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-----
 
MG -

I finally got around to trying your proposed solution, but
am a little too inexpert to understand what to do with it!

I tried looking for the article you referenced, and don't
find anything that specifically describes the print
method, and found the listing under the On Print event was
not very informative...

specifically, I'm wondering what the 'for i = 1 to rs!
SkipLines' piece of code accomplishes, as I assume this is
the line I need to modify to reference the field(?) or
textbox(?) name that contains the value??

I should say that I tried referencing both the field name
and the textbox name, but am not sure I've got the ! or .
referenced correctly, or if this is even how I'm supposed
to accomplish this trick.

If you've got any suggestions, or could provide more
detail, I would appreciate it.

Thanks,

Scott A
 
Back
Top