Darren DICK
d.dick at uws.edu.au
Tue Feb 1 22:30:55 CST 2005
Hello all I want the text in a text box to be blue or red depending on conditions Can it be done in the control source of the Control? I know it can be done via Conditional Formatting or in code Just wanna know if it can be done in the control source EG (pseudo code) =IIf([SomeValue]=-1,Format([SomeControl].ForeColor,"vbred","vbblue")) Many thanks Darren