I have a subform that has some calculated fields on it. I would like to display negative values in red font and show them in paranthesis. How can I do this? I know I can change the font color using conditional formatting, but how best to accomplish the paranthiesis.
Instead of -400 I would like (400) in red.
we are a mixed environment on Office 2000 & 2007