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.


db104.jpg
LVL 1
Dustin StanleyEntrepreneurAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
I  think what you are trying to do is not possible.
0
 
Rey Obrero (Capricorn1)Commented:
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
0
 
Dustin StanleyEntrepreneurAuthor Commented:
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!
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Rey Obrero (Capricorn1)Commented:
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
0
 
Dustin StanleyEntrepreneurAuthor Commented:
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?
0
 
Rey Obrero (Capricorn1)Commented:
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
0
 
Rey Obrero (Capricorn1)Commented:
did you try, opening the subform in design view and add the box, then send to back?
0
 
Dustin StanleyEntrepreneurAuthor Commented:
did you try, opening the subform in design view and add the box, then send to back?
yes
0
 
Dustin StanleyEntrepreneurAuthor Commented:
I am working on the upload now. I would want the box to be Bring to front. Not Send To Back.
0
 
Dustin StanleyEntrepreneurAuthor Commented:
This is a split database so would you want me to just upload the front end?
0
 
Rey Obrero (Capricorn1)Commented:
yes, the front end has the forms
0
 
Dustin StanleyEntrepreneurAuthor Commented:
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.
0
 
Rey Obrero (Capricorn1)Commented:
where is the db?
0
 
Dustin StanleyEntrepreneurAuthor Commented:
Sorry I will try and re-upload it. I thought it went through.
Database1.accdb
0
 
Rey Obrero (Capricorn1)Commented:
which part are you trying to cover?
is the controls in subform sbfrmProdLocations?
0
 
Rey Obrero (Capricorn1)Commented:
you have BOX125 and inside the box you have three subforms....
0
 
Dustin StanleyEntrepreneurAuthor Commented:
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.
0
 
Rey Obrero (Capricorn1)Commented:
can you upload a copy of the BE, so I can see how the forms are laid out in form view
0
 
Dustin StanleyEntrepreneurAuthor Commented:
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.
0
 
Rey Obrero (Capricorn1)Commented:
I don't think what you are trying to do is not possible.
0
 
Dustin StanleyEntrepreneurAuthor Commented:
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.
0
 
Dustin StanleyEntrepreneurAuthor Commented:
This sounds about right. Thanks for your time.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.