only one row printing...why?

[Steve]

I have some code in detail_print to fill text boxes with data. It prints the
first row just fine, but it prints only the first row. My recordset has more
than one row, and the Me.movelayout, me.nextrecord, me.printsection are all
true by default and stay true.

Anyone have any ideas why this is only printing one row?

Thanks!

 

[Gillian]

If all the fields are showing up in design view fine....Go
to the toolbar...FILE-> click on the down arrow if
necessary and CLICK PAGE SETUP...your margins could be
off....look at top or bottom margins...

For example, if the bottom margin is set to 8" it will
display one row at a time b/c of the margin setting....

Let me know if this helped..

Good luck,
~Gillian

 

[Steve]

Well, I thought I had it there for a minute, but nope, it's not a margin
problem. All the text boxes are set to can grow yes, there is ample room on
the sheet. Margins set to .25, on an 11x17 landscape sheet.

I am sure this is something stupid, but I can't find it...

 

[Marshall Barton]

I have some code in detail_print to fill text boxes with data. It prints the
first row just fine, but it prints only the first row. My recordset has more
than one row, and the Me.movelayout, me.nextrecord, me.printsection are all
true by default and stay true.

If you're filling the text boxes using code, what records is
the report working on. What do you mean by "My recordset"?

Is this an unbound report by any chance?

 

[Steve]

Yes, it is unbound. The ultimate goal is a report that has two subreports
that are based on dynamic crosstab queries. At this point I am trying to get
a subreport to work. So the report has no record source, I am opening a
recordset in the report_open module, and assigning values to labels there,
and then in the detail_print section I am filling the text boxes with values
from the same recordset.

 

[Steve]

I got it - I had to set the me.nextrecord property to false...

Yes, it is unbound. The ultimate goal is a report that has two subreports
that are based on dynamic crosstab queries. At this point I am trying to get
a subreport to work. So the report has no record source, I am opening a
recordset in the report_open module, and assigning values to labels there,
and then in the detail_print section I am filling the text boxes with values
from the same recordset.


prints