Results 1 to 2 of 2

Thread: Printing question

  1. #1

    Printing question

    Using Access 2007

    I have been using VB6 for years and have created a lot of forms that open a recordset and print to the default printer. I controlled everything that printed including special lines and text positions.

    For example:

    printer.scalemode = vbCharacters
    printer.currentx = 10
    printer.currenty = 10
    printer.print "This is a test"
    printer.EndDoc

    How does this translate in Access?

    Is there a difference between Access 2003 and 2007 in printing?

    I don't have much hair left and am afraid of pulling the rest of it out.
    ttfn

    Kicker

  2. #2
    VBAX Master CreganTur's Avatar
    Joined
    Jan 2008
    Location
    Greensboro, NC
    Posts
    1,676
    Location
    I have been using VB6 for years and have created a lot of forms that open a recordset and print to the default printer.
    Have you looked into using the PrintOut method? It seems from your description that you're wanting to print a form's recordset, and that's what this is designed to do. Take a look at the details of this method in Access Help.

    Also, if that doesn't meet your needs you can take a look at the PrintForm method.
    -Randy Shea
    I'm a programmer, but I'm also pro-grammar!
    If your issue is resolved, please use Thread Tools to mark your thread as Solved!

    PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003


Posting Permissions

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