Help with report!

[ladivapr]

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! Thanks ahead

 

[mission2java_78]

Are you speaking of the reports page header?

If so certainly. Create a label that just says (continued...)
place it right next to your text box that displays Dog or whatever.
Set it to invisible

Now for some code...
Report level variable
Dim yourKeyField as ????? 'you tell me what the type is

In the onopen event set this to your report text field that you will be comparing

On the page header on format event do this:

If Me.txtYourReportField = yourKeyField then
  Me.lblContinued.Visible=True
else
  Me.lblContinued.Visible=False
  yourKeyField = Me.txtYourReportField
end if

Jon

 

[ladivapr]

thanks

Thats the way to go, I figured it out thanks!

diva