Connecting Tech Pros Worldwide Forums | Help | Site Map

Changing Form Headers Properties

Newbie
 
Join Date: Apr 2008
Posts: 10
#1: Sep 1 '08
Hi there,
I have a database with 30+ forms. The forms were generated using one of the Access 2007 theme. The problem is, when MS office color is changed say to black - everything changes to grey. I want to lock the properties to the state they are now-regardless of the office color. I have considered manually changing the properties but the workload is huge, at least for the time being.
Is there a VBA code that is able to change font color background etc? I am using office 2007
Thanks in advance.
Kassimu
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,714
#2: Sep 1 '08

re: Changing Form Headers Properties


There is, but can you not simply design the forms with the colour you have in mind, rather than any of the system colours?

Otherwise, you can set the background colour of your detail area (for instance) as :
Expand|Select|Wrap|Line Numbers
  1. .Detail.BackColor = ???
Reply


Similar Microsoft Access / VBA bytes