Move Textbox Data to Next Page

S

Sam

I have an Access 2000 report, which pulls its data from a table. Some text boxes have very long text and the textbox may not be enough to show the entire text. If this is the case, I want the Access report to create another page (2nd page) with the rest of the text box data. I don't want the textbox to grow in size, which will overlap with other objects in the report
Is this possible? How

Thanks
 
L

Larry Linson

CanGrow, by design, will not "overlap with other objects" -- it will expand
and then the other objects will print after it. That is, it has the effect
of "pushing" following objects down the report to make space.

Larry Linson
Microsoft Access MVP

Sam said:
I have an Access 2000 report, which pulls its data from a table. Some text
Click to expand...
boxes have very long text and the textbox may not be enough to show the
entire text. If this is the case, I want the Access report to create another
page (2nd page) with the rest of the text box data. I don't want the textbox
to grow in size, which will overlap with other objects in the report.
 
S

Sam

The report is an application form, and I don't want the fields to be pushed down to another page. If a text box has more infotmation than its size, a new report page should be created with the additional information. I don't want to change the actual application design. For example, experience text box. If it exceeds the textbox size, the additional information should move to a new page.
 
M

Marshall Barton

Sam said:
The report is an application form, and I don't want the fields to be pushed down to another page. If a text box has more infotmation than its size, a new report page should be created with the additional information. I don't want to change the actual application design. For example, experience text box. If it exceeds the textbox size, the additional information should move to a new page.
Click to expand...


I think Larry is unavailable for a while so I'll try to deal
with your question.

There is no report feature that could be used to do what
you're asking. If it can be done at all (and I can't see
how), you would have to come up with a tricky query that
calculates two fields that split the long text into pieces.

The one alternative that might get sort of close to the
output you need is to use two fields for the long text. On
your data entry form, use one text box that won't let the
users enter any more text than can fit on the report's first
page and a second text box for the second page's text.
Ugly, but the most I can suggest.
 
Top