INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Rectangles and Lines cause blank page

Rectangles and Lines cause blank page

(OP)
I have a report that the request is to print a border around the body. The body is about 1.5 pages long for each detail section. When I add the vertical line in the report generates a blank page then prints the data. How can I stop this from happening?

I have tried drawing a line that is 10 inches long (to accommodate for the margins) but the second detail record will not print continuous. It moves to the second page I'm assuming because of the 10 inch line.

Hopefully I have explained the issue enough.

Thank you

JJ

RE: Rectangles and Lines cause blank page

If you are interested in placing a line or rectangle on every page, you can use code like the following which draws a rectangle on each page. You can change the 6 and 8 which represent inches

CODE --> vba

Private Sub Report_Page()
    Me.DrawWidth = 6
    Me.Line (0, 0)-Step(1440 * 6, 1440 * 8.5), , B
End Sub 

Duane
Hook'D on Access
MS Access MVP

RE: Rectangles and Lines cause blank page

Also have a look at the margins in page setup - could be too big?

Beir bua agus beannacht!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close