Results 1 to 2 of 2
  1. 09-26-2011, 03:18 PM #1
    desk4tbc
    desk4tbc is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    29

    Question Report automatically printing with no script calling for a print command

    Hi guys,



    I have a bit of a conundrum. I have a report that prints instantly when it is opened via the below code:
    Code:
    DoCmd.OpenReport "rep-eligibility", , , , , Format(Me.[Patient ID], "0000") & Format(Me.cmbInsNo, "00")
    There is nothing in the report itself, so far as coding, that causes it to print on open. Is there an option I am missing? The other reports I have do not have this behavior.
    Reply With Quote Reply With Quote
  2. 09-26-2011, 03:33 PM #2
    desk4tbc
    desk4tbc is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    29
    Figured it out. Forgot to change it to acviewpreview from acnormal.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Printing Automatically Cancels
    By injanib in forum Reports
    Replies: 3
    Last Post: 06-29-2011, 12:16 AM
  2. Print report playing up and print button disabled
    By degras in forum Reports
    Replies: 0
    Last Post: 02-22-2011, 05:04 AM
  3. Printing multiple reports with one command
    By AKQTS in forum Reports
    Replies: 2
    Last Post: 09-24-2010, 09:32 AM
  4. Two same fields in a form Print & Save command?
    By aligahk06 in forum Forms
    Replies: 1
    Last Post: 04-22-2010, 04:54 AM
  5. Automatically print to pdf and change the filename to a field value.
    By russ0670 in forum Reports
    Replies: 1
    Last Post: 01-26-2010, 10:36 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums