Results 1 to 8 of 8
  1. #1
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    149

    set special paper size on a report

    my invoice size is width 3" height 5.5"
    i set this paper size in Control Panel and named it as InvoiceForm.
    however, when in Access's PageSetup, i cannot find InvoiceForm.
    how i can set to this special paper size?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    I assume that you will be using a report to print an invoice.
    Open the report in Print Preview. On the ribbon there are many "Size" settings to choose from.
    If you can not find a suitable size I believe you can create your own with "Page Setup" which is also on the ribbon.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    uoghk is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jan 2022
    Posts
    149
    Click image for larger version. 

Name:	page.png 
Views:	28 
Size:	13.5 KB 
ID:	47310
    do you mean I set the page width & height as above ?

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Quote Originally Posted by uoghk View Post
    do you mean I set the page width & height as above ?
    Yes, I think so. To be perfectly honest it's been a while since I've needed to do this but I think that's what you'll need to do. Suggest you use a copy of the db and have a play with it. Sorry that I can't be of more help. Post back if you're still having problems though. There are many members with a greater knowledge than I have who I'm sure will help.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Try it but I don't think it will do what you want.

    If your printer driver allows you to set custom sizes, seems Access should see it. Which is not what you are getting. My printer driver isn't allowing me to set custom size so I can't verify.
    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.

  6. #6
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I did a search on "Fixing missing custom paper size option". Mostly the results state "The available paper sizes are dictated by the printer/printer driver".

    You might look at these two pages:
    https://answers.microsoft.com/en-us/...1-d9e11d102361
    https://www.dynascape.com/knowledge-...saving-to-pdf/

  7. #7
    dbsitebuilder is offline Novice
    Windows 11 Access 2016
    Join Date
    Jan 2023
    Posts
    3
    I actually found the printer server and added a custom size, but it is not available to me from page layout or 'Size' dropdown in MS Access. I am building a report to print QR Codes on tickets that are 2"x51/2". Ideally, I think it would make sense to output to a PDF first. Any insight would be appreciated.

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Usually best to start your own thread instead of resurrecting an old one.

    What printer are you using? Are these tickets on a roll or 8.5x11 sheet?
    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.

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

Similar Threads

  1. custom paper size
    By kolait in forum Reports
    Replies: 2
    Last Post: 03-11-2021, 02:12 PM
  2. the report size on A5 paper with VBA
    By alifallah in forum Reports
    Replies: 3
    Last Post: 03-10-2021, 04:31 PM
  3. Setting Report to Print on Legal Size Paper
    By najjan in forum Reports
    Replies: 1
    Last Post: 05-26-2016, 09:31 PM
  4. Problem with paper size on a report
    By jackrabbit1962 in forum Access
    Replies: 1
    Last Post: 02-12-2013, 01:46 PM
  5. 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
  •  
Other Forums: Microsoft Office Forums