Hidden labels on screen are not hidden when printing

[pocans]

So I was having issues with report/page footers not showing up how I wanted them. I wanted a few items on all the pages and on the last page some extra information. What I ended up doing was placing everything in the page footer and making the extra information set to visible = false. Then on the last page I would set the extra information to true. In the format property of the page footer looked like the code bellow.

if page = me.pages then
me.item1.visible = true
me.item2.visible = true


end if

so in the example above item1 and item2 is set to visible = false. if page = me.pages(or the last page of the document) item1 and item2 are now visible. The results on screen are perfect. item1 and item2 only show up on the footer of the last page. The results are fine on print preview also. But when I print the page Item1 and Item2 are showing up on all of the pages.

[ranman256]

did you put this code in the ON PRINT event?

[pocans]

Yes, I have tried adding the code to the ON PRINT event and get the same result.

[ranman256]

i use this all the time, and it works.
try:

me.item1.visible = page = me.pages

[pocans]

would this be only in the on print event?

[isladogs]

Just to be sure....

Me.item1.visible = False
Me.item2.visible = False

if Me.Page = Me.Pages then
   Me.item1.visible = true
   Me.item2.visible = true
end if

[pocans]

I solved the issue. I had to add an else on my if statement and set everything back to false for visibility. What was happening was when the form loaded and got to the last page it turned the specific information to visible = true. At that point when the report was printed the information that was set to visible = true and it does not go back to its default visible = false. There was nothing I had to add in print property. Bellow is what I had to alter to get it to work in the format property of the page footer.

if page = me.pages then
me.item1.visible = true
me.item2.visible = true
else
me.item1.visible = false
me.item2.visible = false
end if

Thank You for everyone's help.

[isladogs]

Just to say that my solution was just a variation of yours.
Always specify the visible state using one or other approach