ACC: How to Display the Page Number on a Multiple Page Form

MORE INFORMATION

1. Create the following macro and save it as EmpFormPageNums:
   

         Macro Name   Action
         --------------------
         Page1        SetValue
   
         Page2        SetValue
   
         Page1 Actions
         -----------------------------------------
         SetValue
            Item: [Forms]![Employees]![txtpageNum]
            Expression: "Page #1 of 2"
   
         Page2 Actions
         -----------------------------------------
         SetValue
            Item: [Forms]![Employees]![txtpageNum]
            Expression: "Page #2 of 2"
   						

2. Open the Employees form in Design view, and set the form footer section's Visible property to Yes.
3. Add a text box control to the form footer section, and set the control's Name property as follows:
   

         txtPageNum
   						

4. Set the Employee ID control's OnEnter property as follows:
   

         EmpFormPageNums.Page1
   						

5. Set the Address control's OnEnter property as follows:
   

         EmpFormPageNums.Page2
   						

6. Close and save the form.
7. Open the Employees form in Form view. Note that when you use the PAGE UP and PAGE DOWN keys to view the form, the text box in the form footer section displays the current page you are on by using the Enter event for the first control on each page. This technique works on the first control on each page that has the lowest tab order.