Prev: Export Graph to Word or Excel
Next: Blank Page (header)
From: PJ on 12 Feb 2010 15:14
I have a report with mulitple text boxes in the detail of the report. One of
the text boxes has a number in it. I want the report to output that many
rows on the report even if the other text boxes are blank. Any way to do
this?


Thanks in advance.
From: Duane Hookom on 12 Feb 2010 16:18
Check out Allen Browne's page http://www.allenbrowne.com/ser-39.html.

--
Duane Hookom
Microsoft Access MVP


"PJ" wrote:

> I have a report with mulitple text boxes in the detail of the report. One of
> the text boxes has a number in it. I want the report to output that many
> rows on the report even if the other text boxes are blank. Any way to do
> this?
>
>
> Thanks in advance.
From: Marshall Barton on 12 Feb 2010 16:43
PJ wrote:

>I have a report with mulitple text boxes in the detail of the report. One of
>the text boxes has a number in it. I want the report to output that many
>rows on the report even if the other text boxes are blank. Any way to do
>this?

Not reliably, no. If you can guarantee that all the "rows"
will fit on the current page, then I think this arrangement
should be ok:

At the top of the module, before any procedures, add a line
like:
Private intDetailCounter As Integer

Add group a lowest level based on the field that is used to
uniquely sort the records. In this group header section's
Format event:
intDetailCounter = Me.[the field with the number]

In the detail Format event procedure:
intDetailCounter = intDetailCounter - 1
Me.NextRecord = (intDetailCounter = 0)

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Export Graph to Word or Excel
Next: Blank Page (header)