I have a form with a text box in it (inserted where i
cut out some cells). When I get to the last line in the box, how do I get it
to make a "page 2", where the text continues at the top of the text box on
the second page? I need the Second page to be a copy of the first, but with
a blank text box.

in the text box change event put the following.(You'll need to change the
references to the textboxes and the multipage and also the limit of digits in
the first textbox).

If len(textbox1) = 255 then
Multipage1.value = 1
textbox2.setfocus
end if

"jeramie" wrote:

I have a form with a text box in it (inserted where i
cut out some cells). When I get to the last line in the box, how do I get it
to make a "page 2", where the text continues at the top of the text box on
the second page? I need the Second page to be a copy of the first, but with
a blank text box.