Formatting a Dummy field
Posted on 2016-08-22
I have a union query with a dummy field ("" as AmountDummy in the SELECT statement)
This dummy field doesnt conditionally format in my report. (ie the conditional formatting for <0 and turn text red) and the negative sign on the number doesnt go away on any format I apply. The following is the format I have in the control source on the report:
and it appears like this: -(25.50) - note the negative sign.
How do I format this field red for a negative number and get rid of the "-" sign and use parenthesis for negatives?