Report question, Im desperate!

ladivapr · Nov 18, 2003

Hello guys, I have a question regarding access reports..

Okay I have various reports witht he following problem. My client wants the reports in way that it shows in the header when its a continuation of the information of the before page. Like if a paper is found you can be able to tell there is more information and whatnot. Okay like this:

Page 1

dog--- bone
-------- bone
-------- bone

Page 2

-------- bone
-------- bone
-------- bone

Now I would like Page 2 to look like this

Page 2

dog (continued)
---------bone
---------bone
---------bone

Is there a way I can do this? Like a macro or something? My client just want it this way. They want it to show "continued" when it applyes. Please help me out cause I have no idea how to do this!

ladivapr · Nov 18, 2003

re

Okay I got the answer from other boards thanks for reading

Lister · Nov 19, 2003

Do you want to post the answer? Or the link to the answer?
I was wondering thats all

Rich · Nov 19, 2003

The HasContinued method is one way

Pat Hartman · Nov 20, 2003

The HasContinued method doesn't work for this purpose. It only tests true if a section grows too large to print on a single page and so must be continued.

Here is the code I use in one report. It goes in the format event of the group header. Make sure that you define the variable as static so that it will retain its value between executions:

Code:

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
Static strLastValue As String
If Me.txtFirstLetter = strLastValue Then
    Me.txtContinued.Visible = True
    Me.txtContinued = "Continued"
Else
    Me.txtContinued.Visible = False
    strLastValue = Me.txtFirstLetter
End If
End Sub

Also, make sure that the RepeatSection property is set to Yes.

Lister · Nov 20, 2003

Thanks Pat
Now I see it, I understand it

Report question, Im desperate!

ladivapr

Registered User.

ladivapr

Registered User.

Lister

Z Shift

Rich

Guest

Pat Hartman

Super Moderator

Lister

Z Shift

Similar threads

Users who are viewing this thread