Results 1 to 4 of 4
  1. 03-10-2021, 11:01 AM #1
    alifallah
    alifallah is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    3

    the report size on A5 paper with VBA

    Hello everyone


    How can I adjust the report size on A5 paper with VBA?
    Thanks

    *****-----*****
    please help
    Reply With Quote Reply With Quote
  2. 03-10-2021, 12:14 PM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,895
    Adjust in what way? Resize and shift controls? Probably simplest to build another report. Or export to PDF and print PDF with "fit" option.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 03-10-2021, 01:26 PM #3
    alifallah
    alifallah is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    Aug 2011
    Posts
    3
    I want to print the sales invoice on A5 size.
    Reply With Quote Reply With Quote
  4. 03-10-2021, 04:31 PM #4
    June7's Avatar
    June7
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,895
    I know that and I offered options.

    Can programmatically modify a report to print to different paper size but appears it is not simple.

    Here is example setting to Legal https://social.technet.microsoft.com...rsize-property and another discussion https://social.msdn.microsoft.com/Fo...tom-paper-size
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. custom paper size
    By kolait in forum Reports
    Replies: 2
    Last Post: 03-11-2021, 02:12 PM
  2. Setting Report to Print on Legal Size Paper
    By najjan in forum Reports
    Replies: 1
    Last Post: 05-26-2016, 09:31 PM
  3. Problem with paper size on a report
    By jackrabbit1962 in forum Access
    Replies: 1
    Last Post: 02-12-2013, 01:46 PM
  4. Paper size problem
    By Jack Sheet in forum Reports
    Replies: 4
    Last Post: 07-15-2011, 12:12 PM
  5. Printing the same report to A4 and Letter paper size
    By BKagey in forum Reports
    Replies: 0
    Last Post: 03-06-2010, 01:11 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