Replicate Form color properties

[Pete64]

Basically I want to create a form that allows the users to select there formatting preference for all my database forms. I want the users selection to be replicated through out the whole database on all forms but I dont want to indivdually reference and assign all controls within my database giving code for each one for there values, i would like to be able to save all the users preferences to a database and when they go back into the database the formatting will be what the user selected.

I have no clue really where to start or think about this and need some serious from the professionals.

example
Me.Label43.ForeColor = etc
Me.Label43.FontName = etc
Me.Label1.ForeColor = etc

I dont want this

And help or ideas would be nice .com
cheers
---------
Pete
---------

 

[IMO]

I think this should help

IMO