how do i set an odd and even page in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I desperatly need to know how to change the inside and outside margin on the
odd and even page in an Access Report e.g. picture on top left on left page,
but top right on right hand page, with the report wire bound after.
 
There's really no way to do this within Access easily at all. You may want
to look at whether Blue Squirrel Software's Click Books (which acts like a
printer driver,) will provide you easily the ability to create the offsets
you are looking to produce.
 
I desperatly need to know how to change the inside and outside margin on the
odd and even page in an Access Report e.g. picture on top left on left page,
but top right on right hand page, with the report wire bound after.
Click to expand...

You can determine whether the Page is odd or even using code in each
section's Format event:

If Me.Page Mod 2 = 0 then
' the page is even
' set the left property of all your controls to where they should be
if the page is even.
Me![Control1].Left = 0.5*1440
Me![Control2].Left = 1.5*1440
Me!ImageControl.Left = 0.5*1440 ' Left side of page
ETC.
Else
'The page is odd
' Set the Left property of each control to where it should be if the
page is odd, i.e. move each control 1 inch to the right.
Me![Control1].Left = 1.5*1440
Me![Control2].Left = 2.5*1440
' Move Image control to far right side of page
Me!ImageControl.Left = 5*1440
ETC.
End If

Note: all measurements are in Twips, 1440 per inch.
Make sure you have left room on the page for all the controls to fit
after you move all the controls to the right.
 
Back
Top