Negative percent on a report

[bcoots]

I have this report that shows percentage increases in rates from renewal to renewal. Right now I have the Format as Percent and if there is a decrease in rate it shows 0.00%. I want it actually show the negative percent (ex. -0.07%) is this possible? Thanks!!!

[RuralGuy]

Access can display a negative percent. What value or formula is in the ControlSource of the control?

[June7]

I just tested Percent format on a field with negative values and it works.

-0.13 set to Percent format displays as -13.00%

-0.0007 should display as -0.07%

Do you want to provide project for analysis, or at least the objects related to this issue?