Page Break in Report, based on specific field value

[pdupreez]

Is it possible to insert a page break when a header field changes to a specific content, and only then?

Thanks

 

[LonnieJohnson]

1. Create a footer for the same header.
2. Go to the properties box for this footer.
3. In the Force New Page section of the Format tab, select 'After Selection'

Hope this is what you needed.

prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.

 

[pdupreez]

Hi Lohnie

Yes, that will break on EVERY change in a value, but I need the break only when it is a specific value? Any ideas, as using the onformat procedure has not been successful, unless I used it incorrectly.

Pieter

 

[LonnieJohnson]

You can create an expression and use it in the Grouping/Sorting box instead of a field name.


prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.