asked on Moving controls to front or back in an Access 2003 report without using code
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.
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.
Microsoft Access
Last Comment
Liberty4all
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
<<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.
Yup...exactly.
Jim.
ASKER
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?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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
I appreciate your help and quick response on this. I would not have been able to solve this on my own.
Bryan
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?