Purchase Order Layout

[Rick Toner]

I am kind of stumped on how to make a report continue text on a second page
if it does not all fit on one page.

I have a user that needs a report made that looks like an old form they use.
I know how to make the report look the same height no matter how much data
is on it.

The problem I am having is if a text box has more data then the space
allowed. I have to make the rest of the data continue on the next page.

I need to keep the rest of the page with the same data as the first page.

Any help would be great!

Thanks

 

[Scott]

you can out the data you need to be on both pages in the page header and not
the detail

 

[Rick Toner]

Hi Scott,
I need to show the page layout on all pages. We are automating a PO form
they have had for years. I need to put all of the info on how ever many
pages there are. The only thing that would change is the content on both
pages. I understand that I can put all of the content in the page header and
footer except for the textbox that has the field I need. I just am not sure
how to make the data go to the next page.

Thanks
Rick

 

[John Spencer]

One method that ___might____ work for you is to add a group level that
contains all the information you want to repeat. Then you set the Repeat
Section property of the group to Yes.

You would probably group on the PO number and then the information that you
don't need to repeat would go in the detail section.

The above is speculation on my part, but it is something you can try.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Rick Toner]

Hi John,
I have that part figured out. The part I am having problems with is a Memo
field. The user can enter as much details as they want. I have to figure
out a way to make the text that does not fit in the formatted field to move
to the next page.

I hope I am making since.

Thanks
Rick

 

[John Spencer]

Ok, I have just tested this solution and it seems to work for me. My output
is

Group Header contains:
PO# Purchaser Total Amount and other fields

Detail contains:
Memo field

If the memo field flows over one page, then the group header is reprinted at
the top and the memo field continues with the details.

Settings for Group Header (Sorting and Grouping dialog)
Group on PO#
Keep Together : No
Group Header: Yes
Group Footer: Yes

Group header properties
Keep Together: Yes
Can Grow: Yes
Repeat Section : Yes

Detail:
Can Grow: Yes
Keep Together: No


Group Footer: (no fields or controls in footer)
Force New Page: After

If that does not work for you, then I am stuck.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Rick Toner]

Thanks John,
I will give it a shot in the next few weeks and let you know when I get to
the point of making the report.