Hi everybody

I set up in the Control Panel>Regional setting using brackets for negatives eg (48.60) in place of -48.60.

The issue is: In the Access reports' fields set to format (Standard, 2 decimal place) still show as -48.60. How???

:eek:

Use the Format property of the control
i.e. £#,##0.00[Green];(£#,##0.00)[Red]

I was mislead into Regional option because of Ms' help suggestion esle i would have tried the properties route.. Anyway sincere Thanks:)