Force page break on change of field

[swamprat96]

I have a report that sorts products by category. I want to force a page break when the category changes. The category field is just a text field. I realise that I need to use the Visible property of Page break on an event but I can't remember/work out how to write an event that recognises a change in the text field?
TIA
Tony

 

[vbaInet]

Create a Group Header for Category and set the 'Force New Page' property to 'Before Section'.

 

[GaryPanic]

just had the same thing myself ...took me 20 mins to solve (and i was using the bloody wizard as well - with groupings- had to read the bloody book- that was no help -so back to logic and looked at all of the properties evenywhere -
found it in the end - felt a bit stupid - but it should of word on the wizard .. what gives ...

 

[vbaInet]

just had the same thing myself ...took me 20 mins to solve (and i was using the bloody wizard as well - with groupings- had to read the bloody book- that was no help -so back to logic and looked at all of the properties evenywhere -
found it in the end - felt a bit stupid - but it should of word on the wizard .. what gives ...

Happens to the best of us doesn't it Gary

 

[swamprat96]

Thanks - saved me hours of head scratching

 

[vbaInet]

Glad to have helped.

Welcome to AWF by the way.