L
LPC
Hi. I am a newcomer to Access database and would much appreciate your help in
this matter. I've visited the threads about resetting page number in each new
section in a report and actually pasted the code into my database. It works
well in a report, where the section is the field control of the source query,
but it seems to get "lost" when, in another report, with the same code
inserted (and duly changed where necessary), the section is the result of a
format function (Year: Format$([Date];"yyyy"). The unbound control name
ctlGrpPages goes from Group Page 1 of 3, 1 of 3, 1 of 3, then suddenly 2 of
3, and again 1 of 3, and so on, when there are 35 pages in the report, with 7
sections.
Any idea to the cause of this problem?
Thanks in advance
this matter. I've visited the threads about resetting page number in each new
section in a report and actually pasted the code into my database. It works
well in a report, where the section is the field control of the source query,
but it seems to get "lost" when, in another report, with the same code
inserted (and duly changed where necessary), the section is the result of a
format function (Year: Format$([Date];"yyyy"). The unbound control name
ctlGrpPages goes from Group Page 1 of 3, 1 of 3, 1 of 3, then suddenly 2 of
3, and again 1 of 3, and so on, when there are 35 pages in the report, with 7
sections.
Any idea to the cause of this problem?
Thanks in advance