dicepackage
03-30-2011, 08:45 AM
I have a report that is constantly changing in size depending on user input. At the bottom of page 1 is an address in its own text box. This address will currently split and go half on page 1 and half on page 2 if there is too much text on page 1. I would like it so that Access can detect if the text box will fit on page 1 and if not place everything at the top of page 2. In other words I don't want half an address on one page and half on the other page. Is there any way to go about doing this?