Set Background Color (image) of subform

[TenOc]

While I have used Access for a number of years and have develop a number of applications I have never had to use code. Thus I am VERY new to VBA code. I now have a problem that I think the expression or macro will not solve an I need to do some coding. Please excuse me if I use the wrong words.

I have a "frm_Main" with 4 tabs subform -- call them "subform1", "subform2", "subform3", "subform4". The main form has a background image --call the image "photo1" which is a JPG file. The sub-forms show up with a white background. The users complain about the white background on the subforms.


I assume that I should have an event that triggers when the main form is "current". I have tried for 3 days to write code for the "is current event" of the main form to set the background of the 4 subforms to the photo1 without any success. I have seen sample code on the internet help pages, but when I try to use them I always get some syntex or other errors.

Will someone please give me detail code that I can past into my Access application?

Thanks.

[ranman256]

white is the best color to see black text data.
if the images has white background then it will be white. Images are not transparent.
you can set the background color, behind the image, to any color using form design mode.

you can also set it in the ON CURRENT event:
me.Detail.BackColor = vbRed

[TenOc]

I got it to work by creating a subform and them drag and drop into the correct tab.