Different Background position depending on the page number

[Odradek]

Hello lovely forum,

I hope you can help me. I have a report and I have to add a picture to it. It's a stripe stretching, almost from top to bottom of the page. Easy to do, I used the picture as the background image. But here is my problem. The stripe has to be on the left if the page number is odd and on the right side of the page if the page number is even.
Maybe for reference how it should look like in the end.

 

[isladogs]

One possible solution.
Have two red stripes and make only one visible depending on whether the page number is odd or even.
Use the detail format event for this code.

 

[arnelgp]

using Line method of report object.
will only work on Print Preview.

 

[strive4peace]

hi Odradek

adding onto @isladogs answer ...

to more reliably reference the page number in code, create a (hidden) calculated control

Name --> PageNo
ControlSource --> =Page

 

[theDBguy]

ControlSource --> =Page

Hi Crystal @strive4peace,

I could be wrong, but did you mean to say '=Pages?'

 

[strive4peace]

@theDBguy

I said it right

Page Number
=Page

Total Pages
=Pages

 

[theDBguy]

@theDBguy

I said it right

Page Number
=Page

Total Pages
=Pages

Thanks for the confirmation. Cheers!