Results 1 to 3 of 3
  1. #1
    Khalil Handal is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    310

    Print a form

    Hi to all,
    A form has a Default view: Continuous Forms


    A command button is add on the form to print it (or print preview).
    What VBA code should i use do it ?

    Thanks in advance
    Khalil

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    printing a form is very rigid. You cannot format, you cannot print all the records, only 1 screenshot.
    Its best to just make a report and format it to fit and get all the fields/records.

    docmd.openreport "rMyReport",acViewPreview

  3. #3
    Khalil Handal is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    310
    Hi,
    Thank you.

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

Similar Threads

  1. Replies: 5
    Last Post: 09-16-2019, 01:12 AM
  2. Replies: 14
    Last Post: 10-01-2015, 08:56 AM
  3. Replies: 5
    Last Post: 08-06-2015, 03:26 PM
  4. Replies: 1
    Last Post: 02-21-2015, 11:35 PM
  5. Replies: 5
    Last Post: 07-29-2014, 01:05 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