Calculated field with + sign?

[Hans]

Hi. I am trying to get a calculated field in a report to show a "+" sign before a positive number.
Is this possible, like most other things in Access seem like they are?

 

[David R]

In the Format tab of the control's properties: +0;-0;0;0
(Positive;Negative;Zero;Null)

HTH,
David R

 

[Hans]

Thanks! Now how can I keep the standard format #,###,### and still get the + result?

 

[Hans]

Thanks, just figured it out the second part. I should have checked Access Help a little closer, as my answer is very clear there. Thanks again.