Amy,
In general, this isn't something that Paradox provides a great deal of built-in support, but you can combine calculated fields with some creative design to pull it off in a limited fashion.
The basic technique requires three field objects:
1. The first is bound to the field in question and is formatted so it doesn't appear on the report. (See
for details.)
Name this field object and be sure to keep track of the name; you'll use it in the next two field objects.
2. The second is a calculated field formatted in the way you want positive numbers to appear. It's calculation is something along the lines of:
Code:
iif( hiddenField.Value >= 0, hiddenField.Value, "" )
3. The third is a calculated field obejct formatted to display negative numbers. In this case, you'll probably want to set the color of the field object to yellow or some other color that translates to a nice shade of grey when printed. The calulation for this field object should be something to the effect of:
Code:
iif( hiddenField.Value < 0, hiddenField.Value, "" )
You need to stack all three field objects to get this to work.
Now, this a pain to pull off within the confines of a table frame. For best results in this case, resize the record object and the column containing the data field to much larger dimensions before creating the calculated field objects. This gives you room to use the Clipboard to make copies of the original field object.
It takes a bit of time to set this up, but the results are well worth the effort.
Hope this helps...
-- Lance