• It should be possible to define a function in VBA that is generic in nature, and returns the color sets for each control, and could be called by logic on each form. But I would suggest you consider using conditional formatting on the text boxes. I think you will find that feature of Access 2010 a very powerful tool for displaying data.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!