Ashley said:
In the report design,my report detail can only goes up to 22.
Could I make it longer?
Sounds like on ugly report. But, No, you can not make any
section of a report/form longer than 22".
The first thing you should try is to make any large controls
such as subreport, etc. much shorter and set their CanGrow
property to Yes.
Another thing you can do is create additional levels in
Sorting and Grouping (View menu) base on a constant
expression such as =1. Set each group to have header and
footer sections and spread your controls out over several
sections.
if the above doesn't help and if this is a bound report with
some humongous number of fields in the detail records, you
may have to resort to using one or more subreports.
If this is an unbound report (no record source), post back
with more details and we'll see if we can work something
out.