How do you force a text box on a report page to auto flow into a second page of the report... page 1 and two have different page headers... Can grow is not a viable option as I need the remaining boxes on the page to remain in place... The text box in the report is bound to a text box in a form. The form text box is set to can grow... Any suggestions?

So what's happening now? Is the text box cutting off on the first page?

Yes. It is getting cut off... only if the text length is too long for the cap of the box. The text box is situated between two areas of bound field text boxes. The report is actually a report that employees type. (a state form) so I can't adjust where the text box is situated. If more space is needed the employee goes to page 2 which is completely different. (different header/footer) but the detail section is all blank for text... Hope that made some sense. Sorry I was forced by circumstance to learn this... it is new, but I would like to doit right.

Is the text box bound to a memo field or a text field?

A text field

Ok, Then what you might be able to do is trim the text. Lets say you can fit 150 characters on page 1. So set the controlsource of the box on page 1 to:

=Left([fieldname],150)

Then set the controlsource for the box on Page 2 to:

=Right([fieldname],Len([fieldname])-150)

Gave it a shot, but it did not work.. Thanks for your time. It is difficult sometimes to make sure I am asking / posting correctly... so that you can give an appropriate response. Is my description OK? If not here is another shot... Same form, two pages. First form has a text box bound to a field on my form. The field on the form is set to "can grow" (yes). The text area on the first report is small, the second page of the report is only required if additional space is needed... for the same text field... I just need the text area on the first page to roll, grow, auto expand(teminology?) into the second page... I have no clue where to go... maybe I should start over and rework from the beginning... any suggestions? Thanks again for your time.

Can you attach a stripped down version of your database with just the form and report and what's needed for them?

Getting a text box to span two pages could be a problem.

Ok, I 'll give it a shot. Leave it to me to pick the one thing access can't do??

OK STRIPPED DOWN IS?? I can only get it down to about 750kb in a zip file... sorry for one more question...

Sorry didn't read the whole post, I'll get it.

Well no matter how much I compressed it, even with just the form and report it still is 250kb... I am going to search some more. I appreciate your time... wish I could have been more of a help. If you have any help I'll come back and give it a shot. Thanks again.