Results 1 to 10 of 10
  1. #1
    95DSM is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    37

    Remove Margin from a Pop Out Report

    I have a report that is being a pain. I have already made sure that the "Show Page Margins" is set as No. But I still get the bottom margin. Is there a way to remove the bottom margin or at least set the color (That way I could make it blend in)?

    Please see attached pic to see what I am talking about.


    Thanks,
    95DSM

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    setup the page, reduce the height.

  3. #3
    95DSM is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    37
    Quote Originally Posted by weekend00 View Post
    setup the page, reduce the height.

    There's on a "Width" adjustment on the form, not a Height. Is there a way to change the margin color when the report is in "Report View"?

  4. #4
    95DSM is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    37
    All right I have noticed a difference when I change the Size of the acutal Access application.

    -See right now my report is set to pop up.
    -If I shrink the size of the actual Access application to smaller than what the pop out Report is in Design view, everything fits nicely. But if I Maximize the main Access application the pop out report, when in report view, has the large margin on the bottom. Its matching the size of the open area on the main Access application. Does this help you help me? Because its not helping me help myself.

  5. #5
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    if you want the margin color the same as the report's backcolor, you may try to design the report in a very height size so that the report is high enough to cover the application area even when maximize.

  6. #6
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Quote Originally Posted by 95DSM View Post
    There's on a "Width" adjustment on the form, not a Height.
    While the report itself only has a width adjustment, each section within the report has it's own height adjustment. Have you checked the heights for each section?

  7. #7
    95DSM is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    37
    Quote Originally Posted by ConneXionLost View Post
    While the report itself only has a width adjustment, each section within the report has it's own height adjustment. Have you checked the heights for each section?

    Yes, all of the sections (header, footer, detail, etc.) are appropriately measured.

    Its just wierd that a pop up form can keep its original shape when accessed, but the pop out reports adjust to the size of the actual Access application. So if the main application is Maximized, the pop out report will match the size of the main application. But if the main application isn't maximised and at a smaller size, the pop out report will take its shape. And in this case, everything works fine.

    Very frustrating. I'm assuming this is a mistake on Access's part? I dont know...

  8. #8
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Do you have the "Auto Resize" property turned on or off?

  9. #9
    95DSM is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    37
    Quote Originally Posted by ConneXionLost View Post
    Do you have the "Auto Resize" property turned on or off?

    I have it turned on.

  10. #10
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Try turning it off, then resize the report window and save your changes.

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

Similar Threads

  1. Remove extra page from report?
    By sunny in forum Reports
    Replies: 2
    Last Post: 10-17-2012, 11:30 AM
  2. Anyone help me Remove password
    By nht2007 in forum Security
    Replies: 2
    Last Post: 11-02-2010, 09:20 PM
  3. How do I remove a filter
    By cowboy in forum Forms
    Replies: 7
    Last Post: 04-21-2010, 10:13 AM
  4. remove a password
    By ngeng4 in forum Security
    Replies: 1
    Last Post: 03-30-2010, 05:52 AM
  5. How to remove duplicates
    By TonyBender in forum Access
    Replies: 0
    Last Post: 10-21-2009, 10:27 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