Purchase Order Layout

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

--
Rick Toner

you can out the data you need to be on both pages in the page header and not
the detail
"Rick Toner" wrote in message
...
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

--
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

"Scott" wrote:

you can out the data you need to be on both pages in the page header and not
the detail
"Rick Toner" wrote in message
...
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

--
Rick Toner

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" wrote in message
...
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

"Scott" wrote:

you can out the data you need to be on both pages in the page header and
not
the detail
"Rick Toner" wrote in message
...
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

--
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" wrote:

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" wrote in message
...
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

"Scott" wrote:

you can out the data you need to be on both pages in the page header and
not
the detail
"Rick Toner" wrote in message
...
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

--
Rick Toner

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" wrote in message
...
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" wrote:

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" wrote in message
...
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

"Scott" wrote:

you can out the data you need to be on both pages in the page header
and
not
the detail
"Rick Toner" wrote in
message
...
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

--
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.

--
Rick Toner


"John Spencer" wrote:

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" wrote in message
...
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" wrote:

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" wrote in message
...
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

"Scott" wrote:

you can out the data you need to be on both pages in the page header
and
not
the detail
"Rick Toner" wrote in
message
...
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

--
Rick Toner