Microsoft KB Archive/109821

{|
 * width="100%"|

ACC1x: How to Print Book Style Page Numbers

 * }

Q109821

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SUMMARY
Microsoft Access does not have a built-in format to print page numbers on a report in "bookstyle" format, where odd page numbers are printed on the right side of the page and even page numbers are printed on the left side of the page. This article describes how to print a report with bookstyle page numbering.

MORE INFORMATION
The following example demonstrates how to set up bookstyle page numbering for a report:

 Open the sample database NWIND.MDB.  Create the following new macro, and then save it as Page Setting:

      Condition                Action -      [PageRight] Mod 2 <> 0   SetValue ...                    SetValue [PageRight] Mod 2 = 0   SetValue ...                     SetValue

Page Setting Actions SetValue Item: [PageRight].Visible Expression: Yes SetValue Item: [PageLeft].Visible Expression: No      SetValue Item: [PageRight].Visible Expression: No      SetValue Item: [PageLeft].Visible Expression: Yes  Open the List Of Products By Category report in Design view. Select the Page text box in the report's page footer section. Change the Page text box's ControlName property from Page to PageRight. From the Edit menu, choose Copy. Then, from the Edit menu, choose Paste. A copy of the PageRight text box will appear. Drag the new text box to the left side of the page footer. Change the new text box's ControlName property to PageLeft.</li> Select the page footer section of the report, and change its OnFormat property to the macro Page Setting.</li> Save the report and then preview it.</li></ol>