Access Background

[bradwould]

I would like to change the color of the actual access database background. I've done my forum searching and found many many threads explaining how to do this but i cant open any of the sample DB's. Access says the file is readonly and you need to be able to edit upon the first opening or something to that affect. I assume its becuse the sample is a newer or older access than im running(XP)

Sorry to rehash old threads but i cant get the info from them.
Can anyone help..Grey sucks ha

thanks

 

[reclusivemonkey]

Again Brad, like your "Access Border Colour", this is not down to Access, but to WindowsXP Display settings. Access can colour the forms, the "background" is out of its control.

 

[bradwould]

Maybe I misunderstood but I have seen numerous threads that imply otherwise, GHudson posted a sample I just couldnt open it.

As an alternative... What about changing the background color of the Access window? I use Stephen Lebans SetMDIBackGround function to color the background color of the Access GUI. I then set my forms to popup modals. Once you hide all toolbars and menu bars your Access application has a very custom and professional look. The attached sample shows you as an example on how easy it is for you to change the color of the Access GUI. I left the menu bar visible so that you can unhide the database window and view database objects. This method is application specific so it does not alter the users Access databases on their PCs. You must run the code to color your Access window each time your application is opened.

HTH

I posted the changebackgroundcolor.zip sample near the end of this old thread Hiding Database Window. It is a great way to customize your applications.

 

[ghudson]

The changebackgroundcolor.zip sample I posted at that thread is in Access 97. Just open the db in the read-only mode and it will still work. You just can not make design changes to the db since it is in an older version than what you open it up with but it will still work so that you can see it in action and also look at the code. You can easily import the db objects into your db and it will convert just fine.

 

[reclusivemonkey]

I stand corrected!!! I downloaded the DB, works fine on XP.

 

[bradwould]

Now were talkin'

Great, got it, and it works. Thank you very much. I apologize for making you repeat youself. There are a lot of posts to this effect I just couldnt get it up and running. I dont know what was going on, It maybe because i was trying to open the file from source instead of saving it on my computer.

All is well

Thanks again

 

[ghudson]

Glad you figured it out. I really like using that method to customize the color or my db window since I use custom sized forms.

 

[Laurentech]

I especially like using the background color change technique, then designing my forms borderless with the same color background. It looks like there is no 'form' on the screen, only controls.

Larry