Reports and positioning of manual Page breaks

Hi

I have a report in Access 2000. Sometimes one part of the report is at the
bottom of the page and I would like to force it onto the next page. Because
of the format of the report, the 'force new page' options' aren't useful to
me as the section has 3 separate textboxes and labels that I don't want to
join together because of formating.

So I have tried using the report.top property and object.top to force page
breaks. But I just can't get it to work.

This is what I have been up to:

If me.pagebreak1.top 8000 then ' where 8000 is in twips
me.pagebreak1.visible=true
else
me.pagebreak1.visible=false
end if


Also, each textbox in the section could go over the page, so I need three
separate potential forced breaks.

Where have I gone wrong?

Thanks

Leonard

Presumably you want each of the 3 controls in your section to stay together,
but not necessarily all three. (If you don't care, you could try setting the
sections Keep Together property to No.)

To do that, you need to put the 3 controls in different sections. Open the
Sorting And Grouping Dialog (View menu.) Choose your primary key field, and
in the lower pane of the dialog set the Group Header and Group Footer to
Yes. This gives you 2 new sections that appear for every record (becuase
it's the primary key). Move the first control into the group header, and the
last one into the group footer.

Now you can put page break controls in each section, and use the Top
property of the *report* (not the control) to see how far down the page this
section is being placed during its Format event.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Leonard" wrote in message
news

I have a report in Access 2000. Sometimes one part of the report is at the
bottom of the page and I would like to force it onto the next page.
Because
of the format of the report, the 'force new page' options' aren't useful
to
me as the section has 3 separate textboxes and labels that I don't want to
join together because of formating.

So I have tried using the report.top property and object.top to force page
breaks. But I just can't get it to work.

This is what I have been up to:

If me.pagebreak1.top 8000 then ' where 8000 is in twips
me.pagebreak1.visible=true
else
me.pagebreak1.visible=false
end if


Also, each textbox in the section could go over the page, so I need three
separate potential forced breaks.

Where have I gone wrong?

Thanks

Leonard

Hi Allen

Thanks for that reply. I guess I didn't make it as clear as it should be.

I don't necessarily want the 3 text boxes to stay together. Therefore, there
could be 1 on one page and 2 one the other, or, 2 on one page and 1 on the
other, or 3 on one page.

Leonard





"Allen Browne" wrote:

Presumably you want each of the 3 controls in your section to stay together,
but not necessarily all three. (If you don't care, you could try setting the
sections Keep Together property to No.)

To do that, you need to put the 3 controls in different sections. Open the
Sorting And Grouping Dialog (View menu.) Choose your primary key field, and
in the lower pane of the dialog set the Group Header and Group Footer to
Yes. This gives you 2 new sections that appear for every record (becuase
it's the primary key). Move the first control into the group header, and the
last one into the group footer.

Now you can put page break controls in each section, and use the Top
property of the *report* (not the control) to see how far down the page this
section is being placed during its Format event.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Leonard" wrote in message
news

I have a report in Access 2000. Sometimes one part of the report is at the
bottom of the page and I would like to force it onto the next page.
Because
of the format of the report, the 'force new page' options' aren't useful
to
me as the section has 3 separate textboxes and labels that I don't want to
join together because of formating.

So I have tried using the report.top property and object.top to force page
breaks. But I just can't get it to work.

This is what I have been up to:

If me.pagebreak1.top 8000 then ' where 8000 is in twips
me.pagebreak1.visible=true
else
me.pagebreak1.visible=false
end if


Also, each textbox in the section could go over the page, so I need three
separate potential forced breaks.

Where have I gone wrong?

Thanks

Leonard

Try the suggested solution, with the 3 sections.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Leonard" wrote in message
...
Hi Allen

Thanks for that reply. I guess I didn't make it as clear as it should be.

I don't necessarily want the 3 text boxes to stay together. Therefore,
there
could be 1 on one page and 2 one the other, or, 2 on one page and 1 on the
other, or 3 on one page.

Leonard





"Allen Browne" wrote:

Presumably you want each of the 3 controls in your section to stay
together,
but not necessarily all three. (If you don't care, you could try setting
the
sections Keep Together property to No.)

To do that, you need to put the 3 controls in different sections. Open
the
Sorting And Grouping Dialog (View menu.) Choose your primary key field,
and
in the lower pane of the dialog set the Group Header and Group Footer to
Yes. This gives you 2 new sections that appear for every record (becuase
it's the primary key). Move the first control into the group header, and
the
last one into the group footer.

Now you can put page break controls in each section, and use the Top
property of the *report* (not the control) to see how far down the page
this
section is being placed during its Format event.

"Leonard" wrote in message
news

I have a report in Access 2000. Sometimes one part of the report is at
the
bottom of the page and I would like to force it onto the next page.
Because
of the format of the report, the 'force new page' options' aren't
useful
to
me as the section has 3 separate textboxes and labels that I don't want
to
join together because of formating.

So I have tried using the report.top property and object.top to force
page
breaks. But I just can't get it to work.

This is what I have been up to:

If me.pagebreak1.top 8000 then ' where 8000 is in twips
me.pagebreak1.visible=true
else
me.pagebreak1.visible=false
end if


Also, each textbox in the section could go over the page, so I need
three
separate potential forced breaks.

Where have I gone wrong?

Thanks

Leonard

Thanks Allen, will do that tonight.

Did you watch the world cup qualifier match last night?

Leonard

"Allen Browne" wrote:

Try the suggested solution, with the 3 sections.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Leonard" wrote in message
...
Hi Allen

Thanks for that reply. I guess I didn't make it as clear as it should be.

I don't necessarily want the 3 text boxes to stay together. Therefore,
there
could be 1 on one page and 2 one the other, or, 2 on one page and 1 on the
other, or 3 on one page.

Leonard





"Allen Browne" wrote:

Presumably you want each of the 3 controls in your section to stay
together,
but not necessarily all three. (If you don't care, you could try setting
the
sections Keep Together property to No.)

To do that, you need to put the 3 controls in different sections. Open
the
Sorting And Grouping Dialog (View menu.) Choose your primary key field,
and
in the lower pane of the dialog set the Group Header and Group Footer to
Yes. This gives you 2 new sections that appear for every record (becuase
it's the primary key). Move the first control into the group header, and
the
last one into the group footer.

Now you can put page break controls in each section, and use the Top
property of the *report* (not the control) to see how far down the page
this
section is being placed during its Format event.

"Leonard" wrote in message
news
I have a report in Access 2000. Sometimes one part of the report is at
the
bottom of the page and I would like to force it onto the next page.
Because
of the format of the report, the 'force new page' options' aren't
useful
to
me as the section has 3 separate textboxes and labels that I don't want
to
join together because of formating.

So I have tried using the report.top property and object.top to force
page
breaks. But I just can't get it to work.

This is what I have been up to:

If me.pagebreak1.top 8000 then ' where 8000 is in twips
me.pagebreak1.visible=true
else
me.pagebreak1.visible=false
end if


Also, each textbox in the section could go over the page, so I need
three
separate potential forced breaks.

Where have I gone wrong?

Thanks

Leonard

Didn't see the match, but heard the result.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Leonard" wrote in message
...
Thanks Allen, will do that tonight.

Did you watch the world cup qualifier match last night?