Color in Access Forms

[MickeyFinn]

I am customizing a database for use by several companies.
I would like to specify the companies colour in a table, and have all the forms pick up on on that single color.

The Company info table will only contain a single record.

 

[LittleSmudge]

Yes, that sounds fine. A clear explanation - you obviously know what you're doing and where you're going.

So what bit of that are you having trouble with ?


G LS

 

I've always create forms th getgo, applied a colour or design and poof!

This time around I'e injured my back and can't sit at the computer for more that 5 minutes at a time.

In the control of the form/design view the color palette is displayed when I attempt to change the colour in design view.

Guess I dig ou the books,

Thanks
k'

 

[LittleSmudge]

Do you need different colours for different forms or is it STRICTLY one company - one colour?


If it is one company - one colour then set up a Global Variable called lngCoColour and set lngCoColour to the value of the company's colour just before final compile time.


Then each form's Open event sets
Me.Detail.BackColor = lngCoColor

and if you use Headers, Footers etc you'll need
Me.Section(acHeader).BackColor = lngCoColor
etc .. ..


'ope-that-'elps.

G LS