Results 1 to 4 of 4
  1. #1
    ahuffman24 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    99

    can't change report margin size to less than 0.5"

    Hi,

    I made a report and am trying to fit all of my data on one page. The margins are set at 0.5" by default, and I want to make them smaller. However, every time I try to make them smaller, Access automatically changes them back to 0.5". I can make the margins bigger than 0.5", but it will not let me set them to anything smaller. How can I fix this?

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I believe it is governed by the printer registered as default in Windows. Unless there is a margin option in printer settings I'd say you're beat - at least for that printer.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Wayne is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Location
    Toronto, Canada
    Posts
    6
    If possible, try to make your fields smaller (so long as you are not truncating the data), or concatenating some of the fields together.

    In design view, create a text box, and in the control source line put in the Control Source line:
    Code:
    =([txtStreetAddress] & ", " & [txtCity] & ", " & [txtState] & "  " & [txtZipCode] & ".")
    Just used an address as an example. You would use less space on the report. That's what I did when faced with a similar problem. Works on forms too.

    Hope this helps.

    Wayne

  4. #4
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    If you can upload a zipped copy of the Db we can then take a look at the Report in question.

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

Similar Threads

  1. How do i change Report size in access 1013
    By sam02 in forum Reports
    Replies: 5
    Last Post: 01-27-2017, 10:32 AM
  2. Replies: 0
    Last Post: 08-18-2014, 12:27 PM
  3. Gross Margin calculation in Access 10 report
    By John Donovan in forum Reports
    Replies: 3
    Last Post: 04-13-2014, 11:20 AM
  4. Replies: 30
    Last Post: 09-27-2013, 01:34 PM
  5. Remove Margin from a Pop Out Report
    By 95DSM in forum Reports
    Replies: 9
    Last Post: 12-10-2010, 11:08 AM

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