Change the font colour for the whole form?

[Darrenc]

I've been working on a database for quite a while now, and i've now given it out for testing, and i've come across a little problem. One of the users is colour blind, and the colour theme i've used throughout this database is causing him problems.

I have a function that can single him out when he logs in, question is, is there a way i can change the font colour for the whole database in one go through code??

I have around 12 forms with many controls and labels, i'm kind of hoping i don't have to name each control and label separately to change the font colour.

Please tell me that there’s some clever piece of code that can change the font colour on a form in one hit…..


Regards

Darren.

 

[Oldsoftboss]

Using A2000 look up Label in VBA help. Half way down there is a sub heading call ControlType Property.

 

[alastair69]

Have a look at ForeColor in vba i would think you would need it in the on load event.

Would Think it would be:

Me.Textbox name.forecolour = 0 (You will need to know the colour number)

Have a play about and see.

Alastair

 

[Newman]

Sorry for being a bit out of subject since I don't have any answer to give to you. But, I have a link here that might help you to test the color you choose for colourblindness.
As a colorblind myself, I know how it is appreciated when a programmer thinks about us when they are programming.
Bravo!

 

[Darrenc]

Thanks for the help, its just what i was looking for.
Thanks for the link too, its an interesting problem, its something you'd never think of untill someone points it out.