PDA

View Full Version : Solved: Keep Access report text box in-tact with page break



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?

KOA
03-30-2011, 11:40 AM
Please see:
hxxp://support.microsoft.com/kb/208541 Sorry, had to fudge the link a bit to circumvent the 5-post rule

dicepackage
03-31-2011, 07:31 AM
Thanks for the help. I was hoping there was an easier way but this has allowed me to accomplish what I set out to do.