[AccessD] Dynamic number of rows on a report

Ah, this will do it!

Thanks Ken!

-----Original Message-----
From: Ken Ismert [mailto:KIsmert at TexasSystems.com]
Sent: Wednesday, March 30, 2005 1:44 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Dynamic number of rows on a report


Joe,

>I think I may have been unclear in my description of my problem.
>The need to display a dynamic number of "rows" on my report is to provide
>space on the report for people to manually write in the information by
hand.

The Access RptSampl.mdb has a solution that might work for you. It involves
the Report.NextRecord property. See Access KB 210350: ACC2000: How to Print
a Constant Number of Lines Per Group

http://support.microsoft.com/default.aspx?scid=kb;en-us;210350&Product=acc

The code prints a constant number of lines, but you can easily modify it to
print a variable number.

-Ken


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.