>I have a report which it's expression is a memo field from a table. the memo field data can get to 2 pages in length and in the rpt designer when Idrag the detail bar lower and attempt a preview, I get "detail band is too large to fit on page" It looks like the report does not want to span 2 pages!
>:-(

You don't have to make detail band bigger. Instead go to the report field properties an check Stretch With Overflow.