Solved

# Report - Overlapping rectangles

Posted on 2005-04-18
364 Views
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 ?
0
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.
HANÇER
0

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 !
0

LVL 39

Accepted Solution

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

Steve
0

LVL 53

Author Comment

I already tried that once... without success

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

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.

Steve
0

LVL 53

Author Comment

Thx for the information..
0

## Featured Post

### Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — 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…