Solved

Moving controls to front or back in an Access 2003 report without using code

Posted on 2013-11-21
6
759 Views
Last Modified: 2013-11-22
I have some controls (text boxes and rectangles) in the detail section of an Access 2003 report that, when the report is opened, appear to be stacked on top of each other.  (This is a different question than one asked previously)  Some of these work as expected but others do not.  Some of the controls display in color which requires the back style property to be normal instead of transparent.

Using the format option to send the control to front or back works on some controls but not others.  I'm guessing this means some property setting must be changed to make it work consistently.  I also find that when selecting a group of controls (two or more) to change the format option to send to front or back does not work.  I'm only able to change this format option on one control at a time.

I need to know two things.  First, is the solution to my problem to get the format option to send a control to front or back to work as needed?  If so, what must I do to make that happen?  If not, please advise what I should try to make all the controls display as desired.
0
Comment
Question by:Liberty4all
  • 3
  • 3
6 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39666598
<<First, is the solution to my problem to get the format option to send a control to front or back to work as needed? >>

  I'm not sure what your seeing, but I've never known the send to front or back not to work.

<<If so, what must I do to make that happen? >>

  The only thing that I can think of (and it is confusing), is that when you have more then two controls, it's not obvious in what order their in, nor can you place a control anywhere other then the top (front) of the stack, or bottom (back).

 Because of that, when you have more then two controls, then very often you need to select each control and peform an operation on it.

 For eaxmple, if I had controls A, B, and C and I wanted C on top, B in the middle, and A on the bottom, you would:

1. Select C and do send to back
2. Select B and do send to back
3. Select A and do send to back.

Hope that helps
Jim.
0
 

Author Comment

by:Liberty4all
ID: 39666645
Your explanation of why it's necessary to perform this operation on each control individually as opposed to doing it for a group makes sense.  

Referring to your example for having control C on top, is the reason for sending it to the back before doing the same for control B and A is that when B is sent to the back it puts B behind C, and then A is behind B?
0
 
LVL 57
ID: 39666714
<<Referring to your example for having control C on top, is the reason for sending it to the back before doing the same for control B and A is that when B is sent to the back it puts B behind C, and then A is behind B? >>

 Yup...exactly.

Jim.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:Liberty4all
ID: 39669598
I'm trying to move the controls as you describe above and it's working for some but not others.  Can you suggest what might be causing some not to respond as expected?
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39669891
<<Can you suggest what might be causing some not to respond as expected? >>

 As I said in my first comment, I'm not sure what your seeing, but I've never know the z ordering not to work.  It can get confusing if some of the controls are transparent.

You can try the reverse; select the control you want on the bottom, do "Bring to front", then continue with the next.  The last one you select and bring to front will be the one on the top and the one you should see rendered fully.

Jim.
0
 

Author Closing Comment

by:Liberty4all
ID: 39670006
Jim, the process you describe does work.  I also tried the reverse of bringing each control to the front instead of sending them to the back.  I find that in some cases when neither approach works it's necessary to select the control you want in front to select that and then the order is as expected.  I cannot determine why it doesn't seem to work consistently but when you play with it enough it eventually works as desired.  

I appreciate your help and quick response on this.  I would not have been able to solve this on my own.

Bryan
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

820 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