Page Breaks and tables

[sjassal]

Hello,

I would like to know if there is a way to insert page breaks depending on the output.

Lets say I have a memo field on a report and under that i have a static table (Just lines with some fields so it looks like a table, NOT an access table). now what I want to do is if memo takes up more than half a page then I want to insert a page break after the field so my static table wont break into 2 pages.

Second question is, lets say I have 3 fields in a Tabular format (continous), one of them being a memo field. I wanted the report to show so it has lines around the fields and it looks like a table. On the first try, I inserted the horizontal line right after the fields, that did not work because if memo size increases the line just cuts through the memo. But for horizontal line I have come up with a solution of adding a group header and footer on each field with includes the horizontal lines. The verticle lines are the problem though between the fields.

Thanks for your help in advance.

Sunny

 

[Hayley Baxter]

You can create a macro to force a page break if a condition is met or alternatively you can do this using VBA. You'll need to firstly select the page break control on the toolbox and position this where you would like the page break to appear.

If using a macro you'll need 2 macros, one that sets the page break's visible property to false and another that sets this to true if a condition is met.

If using VBA set it to false:

me.pagebrkname.visible = false

then set it to true if condition met:

if me! [condition] then
me![pagebrkname].visible = true
End if

For your second question have you got your memo field's properties set to can grow, can shrink = yes?

Hay