hide duplicates question

[choppysuey]

If I have a txtboxProfiles textbox in the details portion of my report with the hide duplicates property set to true, if I have more records than it fits on one page then on every new page the value in txtboxProfiles shows up. This is fine but what is the trick so that when the value of txtboxProfiles shows up in subsequent pages to have the word "-continued" after the value? like so

On page 1:

profiles A

Then if records spill onto page 2,3 etc. have:

profiles A -continued

What is the trick in getting this output on the report? Will I need to write a vb function to perform this?

 

[choppysuey]

I ended up having to write a function to do this and attached it to the control source of the textbox. Maybe there was a better/easier way??