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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing Layout Problem

Status
Not open for further replies.

koenc

Programmer
Nov 26, 2002
1
BE
Hello

I have lets say a worksheet with about 3000 lines.
There are title lines and comment lines.
Now when printing i want to keep the title and the comment lines (if there are any) together on one printed page.
The title and comment lines should not be printed on a seperate page but rather together on the next page.

I have a column where I can see if it is a
title (value = 1) or a comment (value = 2)
title2(value = 3) or a comment2 (value = 4).

Does anyone have any suggestions on how do to this.

I also have a form where i can make extra choices such as :
1)do i want just titles
2)do i want just titles val 1 and comments val 2
3)do i want just titles val 3 and his comments val 4
4)or everything
and a print button.
depending on the choices the layout changes.

Now before the print i can check the whole sheet.
But i don't know on what to check.

greetings

Koen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top