Results 1 to 3 of 3
  1. #1
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614

    Report.Line drawing line location varies from pc to pc

    Using the below code to print a border along all sides of report. The line draws correctly on my pc (Win 7, Office 2010 SP1) but the top line is little above the desired the location and intersects an image in the page header section on target pc (Win8, Office 2010). For testing purpose, tried with a blank report and multiple lines changing the sngTop to Me.ScaleTop + 450/ 550 /650 /750. It seems that the top lines are more closely spaced then that of my PC.



    What am I missing ? Why should this behaviour change ? What setting should I look at to rectify ?
    Code:
    Private Sub Report_Page()
    Dim sngTop As Single, sngLeft As Single
    Dim sngWidth As Single, sngHeight As Single
    
    Me.ScaleMode = 3
    sngTop = Me.ScaleTop + 450
    sngLeft = Me.ScaleLeft + 55
    sngWidth = Me.ScaleWidth - 85
    sngHeight = Me.ScaleHeight - 20
    
    Me.Line (sngLeft, sngTop)-(sngWidth, sngHeight), vbBlack, B
    End Sub

  2. #2
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    It's possible the printer on the target computer has a different top margin, which is moving the image down into where the line is drawn.

    The best way to test that would be to try installing the same printer on both computers (temporarily) and seeing if the problem goes away.

  3. #3
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614
    It's possible the printer on the target computer has a different top margin, which is moving the image down into where the line is drawn.
    The image is at top corner of page but the line's top margin is reduced.
    The margins are set via page setup of report. Unable to understand how printer changes margin ?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 11-11-2014, 03:54 PM
  2. Replies: 10
    Last Post: 06-10-2014, 09:03 AM
  3. Line by Line Transactional Data Queries
    By defaultuser909 in forum Queries
    Replies: 7
    Last Post: 07-18-2012, 10:00 AM
  4. Replies: 7
    Last Post: 04-11-2011, 03:58 PM
  5. How to do line by line compare of VB code?
    By Buakaw in forum Access
    Replies: 2
    Last Post: 02-14-2011, 11:46 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums