I have a sub-report that has one text box. The control source for the text box comes from a query. The query includes a field named ForeColor. When the sub-report prints I want the color of the text being printed to be the same as ForeColor. So for example, if the query ForeColor indicates Blue, I want the textbox to print blue. Or if the query ForeColor indicates Red, I want the textbox to print red.
Make sense and how do I do this with VBA code?