Link to home
Start Free TrialLog in
Avatar of Dustin Stanley
Dustin Stanley

asked on

MS Access How To Place a Rectangle Over a Subform. Bring To Front Send To Back Not Working.

I would like to place a rectangle over part of a subform to make the subform look more transparent.


User generated image
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

try setting the BOX property Back Style to Transparent

the send to back should work even if the BackStyle of the Box is set to Normal
Avatar of Dustin Stanley
Dustin Stanley

ASKER

I actually want the box. I colored the box differently so you could better see it. I want the box over the subform and then I was going to color it the same as the background to hide part of the subform. Thanks for your time!
in the design view of your form, right click on the BOX > Position > Send to Back

if that don't work, upload a copy of your db
BOX > Position > Send to Back
That doesn't work. i have tried several times. It covers Labels fine but not the subform.


upload  a copy of your database

What is the best option to remove all information and make a copy of the database structure only to upload?
just create a blank db, import the related forms subform and tables
remove sensitive info from the table or create dummy data

upload the new db
did you try, opening the subform in design view and add the box, then send to back?
did you try, opening the subform in design view and add the box, then send to back?
yes
I am working on the upload now. I would want the box to be Bring to front. Not Send To Back.
This is a split database so would you want me to just upload the front end?
yes, the front end has the forms
It is in the form called frmSkusEntry. After I changed the one rectangle  back style to transparent I couldn't click on it to delete it so I added another rectangle.
where is the db?
Sorry I will try and re-upload it. I thought it went through.
Database1.accdb
which part are you trying to cover?
is the controls in subform sbfrmProdLocations?
you have BOX125 and inside the box you have three subforms....
I am trying to cover the bottom row of sbfrmProdlocations.   sbfrmProducts is layered over sbfrmProdlocations. When I type into sbfrmProdloactions Quantity it generates a add new record row temporally until I click out of the box and at that point the add new record row is removed. So I am trying to cover that action and make it more clean looking. I'm learning as I go.

you have BOX125 and inside the box you have three subforms....

Yes correct. I need box 158 to cover sbfrmProdlocations.
can you upload a copy of the BE, so I can see how the forms are laid out in form view
I am working on it now and putting a few pieces of dummy data in. Look I just started learning this stuff about 2 months ago so to you this may all seem very crazy but I am doing what I know and what will work.
I don't think what you are trying to do is not possible.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I  think what you are trying to do is not possible.
That is probably true. I basically just want to put a square over the datasheet subform. Sounds simple but not in an Access World.
This sounds about right. Thanks for your time.