Article ID: 132144 - Last Review: May 7, 2003 - Revision: 2.0

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

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
This article was previously published under Q132144
Expand all | Collapse all

SUMMARY

Forms that contain more content than can fit on one screen can use page breaks to enable you to use the PAGE UP and PAGE DOWN keys to display the content on different screens. The Employees form in the sample database NWIND.MDB uses this PAGE UP and PAGE DOWN key feature. This article shows you how you can add a text box to the Employees form that, through the use of a macro, displays the current page number when you press the PAGE UP or PAGE DOWN keys.
Back to the top

MORE INFORMATION

To add the page number feature to the Employees form, follow these steps.

CAUTION: Following the steps in this example will modify the sample database NWIND.MDB. You may want to back up the NWIND.MDB file, or perform these steps on a copy of the NWIND database.
  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.
Back to the top

REFERENCES

Microsoft Access "User's Guide," version 2.0, Chapter 24, "Macro Basics"

Microsoft Access "User's Guide," version 2.0, Chapter 25, "Using Macros with Forms"
Back to the top
APPLIES TO
  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
Back to the top
Keywords: 
kbhowto kbusage KB132144
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations