How to add "Continued...." if rows go to next page or column on a report?

[mshakeelattari]

How to add a word "Continued. ..." or any other indicator if some of the rows go to next page or column on a report? Can anybody help me? Thanks in advance.

[NeoPa]

How about a TextBox or Label Control on your Page Footer that contains the text "Continued ..." which can be set up with this value by a Format or Print Event of the Report Header and then cleared (Set to .Visible = False or maybe even set the whole Section to .Visible = False) in the Format or Print Event of the Report Footer?

Let us know how you get on.

[mshakeelattari]

Sorry, I am not much clear. I further try to clarify my question. I have a report in MS Access in which records for a Month are very few while for another month, there are many records some of which may go to next page or next column. In such cases only, we need to indicate on the top of the next page/column as "Continued. .." etc.
For example:

October-2021
============================
Date            ColumnA      ColumnB
============================
Date 1          xyz                    xyz
Date 2          xyz                    xyz
Date 3          xyz                    xyz
============================
November-2021
============================
Date            ColumnA      ColumnB
============================
Date 1          xyz                    xyz
Date 2          xyz                    xyz
Date 3          xyz                    xyz

New Page

Cont.....
============================
Date            ColumnA      ColumnB
============================
Date 4          xyz                    xyz
Date 5          xyz                    xyz
=============================
December-2021
============================
Date           ColumnA      ColumnB
============================
Date 1         xyz                    xyz
Date 2         xyz                    xyz
Date 3         xyz                    xyz
============================

Now, I think, my problem is more clear. I need help in this situation.

[isladogs]

One way of doing this is to use the report page count that usually goes in the footer e.g 2 of 5
In design view, that is written

=[Page] & " of " & [Pages]

To make use of that add a label lblCont to the PageHeader section with caption "Continued ..." and make it hidden by default.

Now add code to the PageHeader format event as follows

If Me.Page>1 Then Me.lblCont.Visible =True

The label will then be shown on every page except the first page.

[NeoPa]

Wouldn't you want logic more like :

Me.lblCont.Visible = (Me.Page < Me.Pages)

[isladogs]

Hi @NeoPa
When I do this in my own reports, I put a "Continued on next page ... " label at the bottom of each page EXCEPT the last.
With that setup, I use exactly the code you suggested.

However, the OP specified "In such cases only, we need to indicate on the top of the next page/column as "Continued. .." etc.
I took that as meaning the OP wanted a label on all pages except page 1 ... hence the code that I posted

[NeoPa]

Well spotted. You're quite right. Essentially he contradicts his first post - but clearly with language issues, so perfectly reasonable.

I would say though, that while your code would work for most cases, it would be preferable to set the value in all circumstances rather than to assume reports only ever progress in one direction. That way if a user returns to the first page they don't get caught out. Something like :

Me.lblCont.Visible = (Me.Page > 1)

[mshakeelattari]

Perhaps I am failing in clarifying my issue. I have a report about some items which have monthly data. Each month has certain number of records date-wise. If all the records of a month end up in the middle or bottom of the page, then its fine. However, in some months, the number of records are so large, or if a month starts near the bottom of the page and only few records come under it while the rest of the records go to the top of the next page, then it will need to mention "continued. .." or any other indication on the top of the next page or else.

[mshakeelattari]

[isladogs]

You should be able to decide which code to use from the above suggestions.
Try them out & see which you prefer. Adapt as necessary. Your choice.

Use monthly grouping in your report and add page breaks after each month's data.
You might also find this article useful in achieving your aim: Group Page Numbering in Reports. That will allow you to start each month's data as Page 1 of ....

[NeoPa]

@mshakeelattari .
If you feel that the advice doesn't match what you need then you need to start by showing that. Not by explaining. Simply stating what you want without any sign that you've even started to work on the issue yourself will only cause people to think you want them to do all your work for you and are not prepared even to try something out and report back on how or why it doesn't match your requirement(s).

You have a lot here to work with. Show us you're interested in putting some work in and then we may understand you better.