page footer

[cluser]

I have a page footer, I only want its content shown on odd page, but not even page, how can I do that?

Thanks a lot

 

[GingerR]

In the footer's On Format event, put this:

Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer)
    If Page Mod 2 = 0 Then Cancel = True
End Sub

it determines if the page is odd or even by using the built-in "PAGE" function and the "MOD" function. If you're not familiar with them, look 'em up )

Hope this helps.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[cluser]

Thank you very much

 

[cluser]

Thanks