Formatting a text box
I have created a fairly regular form that shows a number of data fields across the form with the standard text box object. What I would like to do is set the color of the text and/or the back ground when a certain condition applies.
For example, is the value is positive, black text on a white background. But if the value is equal to zero, lets show the text in red. Maybe red background, with white text?
I have tried using the format property on the text box as you would in MS Excel. eg: "#,###;[red]-#,###"
This does not do the same thing as Excel, but that is the sort of thing I'm hoping to achieve.
Any ideas folks?