[AccessD] Replace negative sign with ( )

I have a report that displays monetary fields with a 'Standard' format,
2 decimal places.

Currently it is showing negative numbers as -1,234.00

How can I make this display (1,234.00)?

I know this can be done if the field is formatted as Currency, but the
client doesn't want to see the dollar sign.

 

Any ideas?

 

Thanks,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030131/3329a6d3/attachment-0001.html>