Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520

    Unanswered: Set printing preferences

    is there a way for me to specify in VBA print orientation?
    So that If use this generic code from the wizard

    Code:
     Dim stDocName As String
        Dim MyForm As Form
    
        stDocName = "BOP_Frm"
        Set MyForm = Screen.ActiveForm
        DoCmd.SelectObject acForm, stDocName, True
        DoCmd.PrintOut
        DoCmd.SelectObject acForm, MyForm.Name, False
    I can make it print landscape?
    Darasen

  2. #2
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    Hiya Darasen

    I was playing with this when trying to get pages to pull from differant trays. Looks like forcing/changing orientation is no simple task. There's some good coding samples here too:

    http://ourworld.compuserve.com/homep...Tip.htm#LAYOUT

    Have a good one.

    - Chris

  3. #3
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    Thanks. That is funny as I was looking at the same page yesterday before I posted here. Having trouble to get it to do exactly waht I wanted so I thought I'd ask if there were an easier way.
    Darasen

  4. #4
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520

    Eureka !

    FOUND IT !!

    Code:
    Application.Printer.Orientation = acPRORLandscape
    Darasen

Posting Permissions

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