Full Version: formatting negative numbers
UtterAccess Discussion Forums > Microsoft® Access > Access Tables + Relationships
michaela4
Aug 24 2007, 10:30 PM
How can I format a field on my table to show a negative number with the minus sign instead of parenthesies?

-366 instead of (366)

Thanks

Michael
Rainlover
Aug 24 2007, 10:40 PM
Formating with

Data Type as Number
Field size as Double
Decimal Place as Auto

Should do the trick.

If not what have you got?
HiTechCoach
Aug 24 2007, 10:49 PM
? Format(-366,"#")
-366

? Format(-366,"#;(#)")
(366)
michaela4
Aug 27 2007, 12:52 PM
I forgot to mention it has to be a currency data type.

thanks
Michael
balaji
Aug 27 2007, 12:54 PM
Will the below work for you?
QUOTE
?format(-366,"$#.00")
-$366.00
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.