blank page caused by pagebreak

[Ming]

I have a report that is grouped by compnay name and then technician Name. The
requirement is --> each technician info per page. I added a pagebreak in the
Technician group footer to meet the requirement. Because the pagebreak in the
Technician group footer, the last page always blank.

I added the following codes in the detail_format event to prevent user to
see the last blank page:
If Me.Page = Me.Pages - 1 Then
GroupFooter2.Visible = False
Else
GroupFooter2.Visible = True
End If

The above code works fine so the users will not see the last blank page.
However, when I print it. It print the report without pagebreak.

I want to hide the last blank page from viewing and also not to print the
last blank page. Is there any way to do it?

 

[leabee1]

Is it just beacause of the width of your report? Maybe its just that your
report is running over the page and that is why it is having a blank page.
Try just checking your widths on everything?

 

[Boyd \Hi Tech Coach\ via AccessMonster.com]

The last page is always blank because that is what you are telling Access to
do.

Normally this is not done by adding the page break control.

There are report properties that woill handle this for you.

You should set the property for the group footer to "Force new page" = "After
section".

Hope this helps...

 

[Ming]

Hello Boyd,

Thank you so much for your help. I made the changes based on you suggestion
and it works.


Best Regards

Software Developer

 

[Ming]

Hello,

Thank you for your responding. I made the changes based on Boyd's
suggestion. It works as required now.

 

[Ming]

Hello Boyd,

I am doing testing now and noticed that if I set "Force new page" - "After
section", it will print one entry per page all right.

However, the requirement is one technicain per page. Under tech group, it
lists tasks base on the Tech name. Sometimes one tech can have multiple
tasks.

 

[Ming]

Hello Boyd,

You can ignore my last message. I found a way to do it. Thanks