Avatar of amkazen
amkazen
Flag for United States of America asked on

Subform Backcolor or Transparent Color Code

Hi,  I have a main form with two subforms.  The main form has a picture the customer likes and wants to see.  However, the two subforms appear as white boxes on the main form picture.  The customer does not like this and wants me to make the subforms transparent.  I have searched for hours on the Internet (agoogle, Yahoo) over the past two days and been to many sites and cannot find the answer, at least one I like.  I am finding a few answers that says this cannot be done.  A few answers said to put the same picture in the subform and then align it with the main form picture but this cannot be done as it is too dificult to line the pictures up.  Some of the answer did not aply to Access 2003 SP2.

There has to be a way to do this.  Is there a transparent color code?  Do I have to remove the subform from the main form and have the user access the subform data entry fields by clicking on a control?  This might work when adding a new work request but not when viewing the existing work requests.

Because of the time I have spent unsuccessfully looking for this answer, I am assigning this question 500 points!  My customer wants this form done this week.  Thanks for your help.

Andrew

Here are the settings:
Subform Box: Special Effect...Flat
                     Border Style....Transparent
                     Border Width....Hairline
                     Border Color....0
Subform Form:  Default View....Single Form
                        Allow Form View...Yes
                        Scroll Bars...Neither
                        Record Selectors....No
                        Navigation Buttons...yes
                        Dividing Lines....No
                        Picture....(none)
                        Palette Source....(Default)
Subform Detail Section:  Back Color....16777215
                                    Special Effect...Flat

Microsoft Access

Avatar of undefined
Last Comment
amkazen

8/22/2022 - Mon
SOLUTION
mpmccarthy

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
jjafferr

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
amkazen

ASKER
Thank you both for the help.  

I do not like the constraint of not being able to set the background to transparent but.....whay do I know? There must be a reason for it.

I  will redesign the form as I have been granted full authority to change this exisiting/inherited database application in any manner I see fit as long as I stay within the customer requirements.  So, I will add a button the user can click to call up a new form to enter the Requester info.  I will also modify the exisiting request form so the user can see exisiting request.  In other words, there will be a form to enter new requests, and there will be a very similar looking form to see previously entered requests.

Thanks again!
amkazen

ASKER
Is there no way for me to edit my comment?

I spelled "what" incorrectly, spelling it as "whay".

Also, the word "request" in the 8th line should be plural.

What a goofy (being nice) feature to have if I am unable to edit my comments.
jjafferr

> Is there no way for me to edit my comment?
No, and that is the fun part, where we all can have a break and have a smile on our faces :)

thanks for the points.

jaffer
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
amkazen

ASKER
I am smiling........