Conditional Page Break

  • Thread starter Thread starter rbellis
  • Start date Start date
R

rbellis

I need to create a conditional page break that is based on a text box.
I know where to place the page breaks and how to set it as true and
false. I am having problems with the IF statement. I just need the
page break to happen when the text box data changes. This is not a
text box that is having data entered it is being pulled from a table.
Can someone please help.

Thank you
 
If the text box is not having data entered, when is the data getting changed?
You can use the On Dirty property when a record has been changed but I think
we might need some more info from you.

Jackie
 
Jackie said:
If the text box is not having data entered, when is the data getting changed?
You can use the On Dirty property when a record has been changed but I think
we might need some more info from you.

Jackie
Click to expand...

The data in the field gets changed from the table. so txtbx1 on the
report changes when it goes down through the rows.
 
Try putting your text box in the sorting and grouping, having a group footer
and putting the page break in the footer.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Page Break Challenge 1
Condition in macro 1
Excel Delete Multiple Page Breaks w/in Selected Rows 6
Word How do I insert a conditional page break during a word merge? 1
Page Break on Form 5
Section Breaks in Excel 5
Page break 1
Excell 2003 has page breaks everywhere 2

Back
Top