Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Pagenumber in Access-97 [Page] of [Pages]

0 views

Skip to first unread message

unread,

Jan 4, 2000, 3:00:00 AM1/4/00

Hi there!

I have a little problem with conditional newpage i reports.

Consider the following code as suggested by Access itself.

Private Sub Detailsektion_Format(Cancel As Integer, FormatCount As Integer)
If Me![Prtakt] = "S" Then Me![ConPageEject].Visible = True
End Sub

Private Sub Detailsektion_Print(Cancel As Integer, PrintCount As Integer)
Me![ConPageEject].Visible = False
End Sub

Private Sub PageHeader_Format(Cancel As Integer, FormatCount As Integer)
Me![ConPageEject].Visible = False
End Sub

[Prtakt] is a field in each record
[ConPageEject] is a 'conditional pageeject' in the detail-section in the
report.

Now,,,
The page ejects go ok, but in the reportfooter the pagenumbering goes wrong

Page [Page] of [Pages]

It is the [Pages] that counts wrong. In a report with 3 pages it reads:
Page 1 of 5
Page 2 of 5
etc.

Can anyone come up with a solution to this, I would be very greateful.

0 new messages