Results 1 to 3 of 3
  1. #1
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Margins (A2003 SP1)

    I have a few landscape reports which seem to keep reverting to portrait. I've removed Name Autocorrect (the problem in A2000). I even had one report which printed the first one (became two) pages portrait and the rest landscape!

    The database is in Access 2000 format (an mde file created in A2000)
    SP1 seemed to cure some but not all reports!

    Any gurus got any ideas/experience of this?

    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> <img src=/S/aflame.gif border=0 alt=aflame width=16 height=16>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Margins (A2003 SP1)

    With further testing it appears to be a printer issue, not an Access one. The HP 4100N causes the problem. Switching to another printer/photocopier (Konica) seems to cure the problem. Being on a network I guess I'll have to 'grin and bear it!' <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Report Margins (A2003 SP1)

    Hi Steve,
    Actually, this is an ongoing problem with Access - we see it even with SP3 installed. And most frustratingly, we see it on MDE deployments where we ship a copy to a user's workstation and the reports reset to the default printer rather than the specified printer. You can circumvent part of the problem by previewing the report, then right clicking and choosing Page Setup, but of course if you are working with an MDE, you cannot save the setting. Access 2002 introduced some capabilities to set print properties in code which does make things easier. It is also possible to use Windows system level calls to specify print settings, but it's an ugly alternative and fraught with compatibility problems.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •