access+training+in+london - Access and reports

Hello Sue,
Thanks for your post, to solve your problem, open your report in design view, select the control to which you wish to apply the rounding, open the properties page for the control, in the Format row enter the following code: #,##0,;[Red](#,##0,);-

This will only return the Thousands values, and will give negative numbers in red surrounded by brackets ()

hope that now works

Pete