Access 2003 Background Color

[joedem]

In A97 the color of the application background (not objects - just the area the objects sit on) is directly controlled by Windows appearance settings. Obviously not so in A2003 unless there is a way to tell A2003 to do so. And the default color is, well, not acceptable.

I distantly remember that there is a way to change the color in A2003 (perhaps my old brain is playing tricks) - but haven't a clue what it is. Is there a way? Any help *much* appreciated. I've searched Help and online to no avail.

TIA

Joe

 

[dRahme]

In Acc 2002 - Tools, options, background - select what you like.

 

[joedem]

Thanks for the reply - but I must be dense. I went to Tools/Options on the A2003 menu (and on A2002 as well)... and no Background tab. Looked through all the options (I tried that before with no result). What tab is this under? Is there an add-in I don't have?

Sorry to be so slow, but this is driving me nuts.

Thanks

 

[dRahme]

Whoops, Sorry - I didn't look at the question as close as I should have. What I was referring to was the background of a data sheet. I amy be wrong about this but I do not think there is way to set a form background color as a default.

I store the colors I use in a table and then call the color from the form:

Create a Function:

Function FormColors(frm As Form)

frm.Detail.BackColor = DLookup("[frmColor]", "tblColors", "[cID]=1")
frm.FormHeader.BackColor = DLookup("[frmColor]", "tblColors", "[cID]=2")


End Function

Then in the form's on load event:

Call FormColors(Me)

Hope that helps.

 

[joedem]

Thanks. But actually I wasn't looking for form colors (I've got that well in hand), but for the general background color for Access 2003 - the color of the background when Access comes up, before a database is loaded (and serves as the background behind application objects). On another forum I got a reference to a site where one can download VBA code to cause the color to change. I spliced it into my app and call it in AutoExec.

I'd rather have it permanently changed than have to add the routine to all databases - but works well for now until I can get that figured out.

Thanks for taking the time to respond. I do appreciate that.

Joe

 

[ZmrAbdulla]

It is not possible in a normal way. See Leban's

changemdibackground is a database containing a function to allow you to specify a color or Bitmap Image for the background of the main Access MDI window. NO SUBCLASSING REQUIRED!

Leban's changemdibackground mdb

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[joedem]

Right. That's the one I used. Thanks.