Hiding Last Page Header fields

[toptech]

Hi There.

My problem is as follows:

I am printing the page header on my report - works fine

I have a field that displays the warehouse name on each page. That is great too.

On the last page, I have grand a grans total for my report, but the page header has the most current warehouse displaying on the top.

I would like to hide that warehouse on the final page.
I am currently at a loss.

Any thoughts on this would be a great help.

Thanks in advance.
Jeff - Top Tech


Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.

 

[dhookom]

You can try change the control source of your text box to something like:
=IIf([Page]=[Pages],Null,[warehouse])

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[toptech]

Hi Duane.

Thanks for your help.

Your page checking put on the rigt track. I just changed waht you gave a bit and it did the job.

Again, thanks for your help.

Regards,

Jeff

Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.