Report - Overlapping rectangles

Posted on 2005-04-18
Last Modified: 2008-01-09
Following situation:
I've got a report where a graph on it. There are also 2 rectangles (1 red color and 1 blue color - Rectangle BoxNewWages3 (red one) & BoxOldWages3 (blue one)) that are adjusted to 2 variables. Sometimes, they fall together (thn I only show the BoxNewWages3 rectangle (which has a red color).
When the overlap each other (so we'll always see 1 complete and 1 a piece).
Now the problem is that I always want the red one above the blue, but I don't know how to achieve this.
Can someone help me ?
Question by:Dhaest
    LVL 1

    Assisted Solution

    Why do not you try to change the color of rectangel programmatically. When you want the blue one on top then make the red one trasparent. OR if you want to make the red one on top then make the blue trasnparant.

    But i think there is not a menu like in Excel or Word that you can send one to back of the other object.

    Hope this idea is helpfull to you.
    LVL 53

    Author Comment

    I must see the blue and red dot. It's not possible to make one of the two transparant, because I need to see them both if necessary.
    The red must come on top of the blue !
    LVL 39

    Accepted Solution

    Open the report is design view, select the red rectangle, the select the Formast --> Bring to Front menu item.

    LVL 53

    Author Comment

    I already tried that once... without success

    I recreated my report and now it's working ! Can someone explain that ?
    LVL 39

    Expert Comment

    It has something to do with the Z Order which normally you can change with the Format --> Bring to Front, Send To Back but if it did not work when you tried it ... I can't be sure. When you design a report the ZOrder is done by the order that you add the controls to the report so I guess you added the Blue rect and then the Red rect.

    LVL 53

    Author Comment

    Thx for the information..

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now