<div>
Hi tonikaram,<br />
<br />
You can add a groupheader to your report that groups on the week field. Then in the properties of that groupheader in the format tab, you can specify that you want to &quot;Force new page&quot; &quot;&nbsp;before section&quot;.<br />
And it's all done<br />
<br />
Regards
</div>


Hi tonikaram,

You can add a groupheader to your report that groups on the week field. Then in the properties of that groupheader in the format tab, you can specify that you want to "Force new page" " before section".
And it's all done

Regards

<div>
sorry dbase118,<br />
<br />
The darn thing didn't show your comment prior to me submitting mine.<br />
<br />
regards
</div>


sorry dbase118,

The darn thing didn't show your comment prior to me submitting mine.

regards

<div>
no problem...2 experts are better than one
</div>


no problem...2 experts are better than one

<div>
Another solution is to add a pagebreak control set it's visible prop to False.<br />
Then use VBA to check if the value has changed and set it to visible whenever that has happend.<br />
<br />
..but i guess the solution suggested is simpler..<br />
<br />
perove<br />

</div>


Another solution is to add a pagebreak control set it's visible prop to False.
Then use VBA to check if the value has changed and set it to visible whenever that has happend.

..but i guess the solution suggested is simpler..

perove


<div>
<div class="content wysiwyg-content">
All,<br />
<br />
I would like my reports to start a new page if the field &quot;week number&quot; has changed. A week can have many records (each containing the field &quot;week number&quot;) and some weeks contain only one record.<br />
so I would like the report to start on a new page whenever the week number has changed to a new value. <br />
this makes the conditional macro completely useless since the condition has no &quot;previous row&quot; option. only conditions available are if week number = 30 etc, but not if week number changed from previous row...<br />
<br />
anyone can help?
</div>
</div>


All,

I would like my reports to start a new page if the field "week number" has changed. A week can have many records (each containing the field "week number") and some weeks contain only one record.
so I would like the report to start on a new page whenever the week number has changed to a new value. 
this makes the conditional macro completely useless since the condition has no "previous row" option. only conditions available are if week number = 30 etc, but not if week number changed from previous row...

anyone can help?

conditional page break, based on DATA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.