Colour

[Pauldohert]

Does anyone know - or how do I find out the "background" colour for access - ir the dark grey behind forms in datasheet or behind the database window.
Is this standard on any machine?


Thanks

 

[Russyfoot]

Colour management

You can change the colour of datasheets, including font and gridlines, by selecting format then datasheet, when in datasheet view. This will change the colours for all datasheets.
For forms, click on the form property button when in design view & scroll down, you can select colour there. You can also select different backgrounds for the form header,details and footer backgrounds.
The background colour for the Main access window is that in your settings for Windows.
hth

 

[Pauldohert]

Thanks - but I mean the empty grey bit which the datasheet sits on top. Sorry I'm sure there is a correct tem for this but I don't know it.

 

[Russyfoot]

Application background

Ah. Missed that one. It's the application background item on the appearance tab in Windows display properties. This will change the background for ALL appications not just Access.

 

[Pauldohert]

Aha - excuse the further dumb question - how do I find out what colour it is to use it within access itself?

Thanks again!

 

[Russyfoot]

I don't know if you can. I can't think of a way to do it.

 

[Pauldohert]

Ok - Thanks

 

[Jonno]

Paul

I guess a way of doing it would be to make small a form with no border at all, guess the closest you can and keep making adjustments until it disappears into the background and you have a good enough match, then you have your colour numbers from the properties.

Jon

 

[The_Doc_Man]

Aha - excuse the further dumb question - how do I find out what colour it is to use it within access itself?

There is a way to do this, though it is a bit tedious. Get to a module pane, open a module. Even an empty one will do. Now open the Object Browser. Use the binocular icon to search for "Color" and ignore all the object properties for things like forecolor, backcolor, and bordercolor.

One of the things you will see will be a list of color definitions. You might have to browse through more than one such list before you find the right one. There are names representing the colors that come from the Windows Style info. Basically, normal Access colors are 24 bits, stored in a LONG so they have 32 bits, of which 8 are zero. BUT for these colors, the sign bit is set and there is some pattern to the bits. Basically, negative colors. When Access sees that, it grabs the color from the Windows palette.

So to get the color of the tab background, or any other Windows-based color for that matter, just browse through the Object Browser to find the name. That should do the trick for you.

 

[Robert88]

Application background on your Form background....

Goto the Advanced Tab in the Display Properties Dialog, Select the "Advanced" button. Then in the Advance Appearance dialog select the "Item:" as Application background. Then select the Color box dropdown and goto the "Other" button. This will take you to the Color Dialog, showing the following properties:

Hue:160 Red:128
Sat:0 Blue:128
Lum:120 Green:128

(These properties consititute your dark grey background)

Then in Microsoft Access in Desgn View of a Form, right click on the background of your form and select "Properties". Select the button to the right of "Back Color" to bring up the same Color properties above and transfer the properties above within. Then select "Add to Custom Colors" and "OK".

Your Form back color should now look like the application background...

Not sure if this completely correct as it looks slightly different but it certainly gives you more to play with, good Luck..........

 

[Pauldohert]

Thanks Everyone - Got it!

 

[skea]

Well, ive also been thinking about this!!. One can do this through Display settings and changing Application Background Color.
But:- This Changes the Background Color Of MS Applications On The
Developer's PC!. How can we do this in code so that if My Application is
transfered to another PC, then the Application Back Color is too changed
there.

I dont know whether Pauldohert got it but if any one has done this, plz make my day!

 

[Pauldohert]

Hi skea - no I never got to change the "application background" the way I wanted - only as you describe - I wanted to change it to white. The bit I got was how to get what the colour actually is to use it elsewhere.

Paul

 

[skea]

Thanks Paul.

 

[ghudson]

You can easily change the background color of the database window. I use Stephen Lebans SetMDIBackGround function to change the background color of the Access GUI. Check out my attached changebackgroundcolor.zip sample I created using his function.

This subject and more tricks are discussed in this thread... Hiding Database Window

 

[skea]

Yes!!. Your the Man. I had looked at your thread earlier but this is what i wanted.