Show All

Hide All

The following is a list of examples of page number expressions you can use in form or report Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.) and the results that you will see in other views.

• Expression: =[Page]

  Result: 1, 2, 3

• Expression: ="Page " & [Page]

  Result: Page 1, Page 2, Page 3

• Expression: ="Page " & [Page] & " of " & [Pages]

  Result: Page 1 of 3, Page 2 of 3, Page 3 of 3

• Expression: =[Page] & " of " & [Pages] & " Pages"

  Result: 1 of 3 Pages, 2 of 3 Pages, 3 of 3 Pages

• Expression: =[Page] & "/"& [Pages] & " Pages"

  Result: 1/3 Pages, 2/3 Pages, 3/3 Pages

• Expression: =[Country] & " - " & [Page]

  Result: UK - 1, UK - 2, UK - 3

• Expression: =Format([Page], "000")

  Result: 001, 002, 003