Access 2013 - Printing a page Header in the right / left margin

I have a standard report that I print as a PDF and then add "Preliminary Report" on each page in the outside margin (for printing two sided).

I would like to have access print the report with the  "Preliminary Report"  with the same 'look'

See attached file

Does anybody have experience with something like this?
Report-Sample-Pages.pdf
rogerdjrAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
you might try Steve Leban's RotateText code.

I have not had a need to use it recently (since 2003) but was using it quite regularly at the time for a very similar reason.
0
rogerdjrAuthor Commented:
I understand how to rotate text

The question is how do I put it in the right margin half way down the page on odd pages and the left margin halfway down the page on even pages
0
Gustav BrockCIOCommented:
One option could be to have a main report only holding the header and footer and two pictures (bitmaps of the red text) which you hide one or the other controlled by the page number.
Then turn the current report into a subreport to fill most of the main report between the two bitmaps.

/gustav
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

IrogSintaCommented:
You can have two rotated labels or images (one on each side) and add code similar to this in the OnFormat event of the header:
    Dim pageIsEven As Boolean
    
    pageIsEven = Int(Me.Page / 2) = (Me.Page / 2)
    Me.lblLeftPrelim.Visible = pageIsEven
    Me.lblRightPrelim.Visible = Not pageIsEven

Open in new window

Ron
0
rogerdjrAuthor Commented:
Good so far - having trouble getting the header "Preliminary Report" print in the side margin half way down the page

When I place it in the header section it prints at the top and makes the header too "tall"

Is there a way to add a watermark in the background similar to a word document?

Thanks
0
Gustav BrockCIOCommented:
Move the bitmaps/labels to the detail section.

/gustav
0
Dale FyeCommented:
You might try creating a separate report as the frame for you left/right margin labels and then embed your other report within the details section, as a sub-report.

I'm not certain how this would affect the even/odd page code that Ron (IrogSinta) posted, you may have to refer to use the main reports Detail_Format event,  Or use the sub-reports page header event and refer to the main form:

me.Parent.lblLeftMargin.Visible = ...
me.Parent.lblRightMargin.Visible = ...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.