Make a formula as "Test Page Break".

In the formula put:

Place this on the section you have the memo field displayed.

This formula should return a 0 whenever the "specific text to search for" is not in the memo field (table.field) or the number of characters where that string starts if it is in the field.

to make the search not case sensitive add another part to the end so it will be:

If it was just the case sensitive and you can get it to give you a value > 0 then move that into the expert and just add the >0 onto the end of it (so it only does a page break when it finds the string).

 

If so and you need more help can you answer the questions I first asked and then explain what you did to add in the formula for the page break.

Thanks

1. Open Section Expert.

2. Click on the Details section to highlight it.

3. Uncheck the "new page after" check box.

4. Click on the formula box to the right of the New page after (the x-2)

5. Put the formula in here ( instr({memofield},"what i'm looking for",1)>0) and save and close.

6. Verify the X-2 next to the new page after is RED (while the details section is highlighted).

7. Hit OK.

 

If this does not work then something else is going on here. You have validated that the formula works in 2 different ways. As long as the formula was placed in the correct section AND the field resides correctly on that section then is should work.

If you are trying to do something else like a new page after a group footer  only when one of the detals rows of that group has this vaule then this won't work. You would have to sum the instr formula on the group and then add new after if teh SUM >0.

So again if the above does not work I would need to know exaclty what section you are trying to do a new page after and what is on that section to assist more.

Hope this helps.