Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Partially Printing Textbox Labels - Need to Force to Next Page

Status
Not open for further replies.

PennyR

Programmer
Jan 14, 2005
8
US
When printing a form that prints out many 11 x 8 1/2 pages per record, my textbox labels which may be 1-4 lines long print a partial line of top half of letters on the bottom of one page and the bottom half on the top of the next page when space runs out at the end of the page. Textboxes behave properly. Page breaks before the labels cannot be predicted because user's input can be 0-4000 characters for each of the dozen or so textboxes all of which have labels.

I am using Access 2002 with XP Professional OS and an HP printer.

I have set:
* textboxes (nvarchar (4000)) to can grow
* labels do not have this property but controls are large enough to show entire text to be printed
* detail section can grow (because the 4+ pages get cut off when set to 'No'- in design view the detail section measures 10" long

How can I force the entire label to print on the next page if there is not enough space on the current page? If not entire label, then how about individual lines?

Thanks.
PennyR
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top