-$4,650.00 is the default Currency format. If you are seeing
($4,650.00) then someone has set the Regional and Language settings to
use the parenthesis instead of the - as the negative value symbol.
Click on:
Start + Control Panel + Regional and Language Options + Regional
Options + Customize.
Change the negative number format from (1.1) to -1.1.
Any changes here will of course be reflected in ALL programs, not just
Access.
If you don't want to (or can't) change the Windows settings, then you
can display any valid format you wish.
Simply set the Format property of the column to:
$#,##.00;-$#,###.00;0.00
However, I would do it at the very end of the process, i.e. in the
form or report that will be displaying the value, not in the query.
Look up Format Property + Number and Currency datatypes.
I checked and the lanquage settings are already set to - instead of () and
the $#,##.00;-$#,###.00;0.00 didn't make a difference. Strange. I figured
that would work for sure.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
