Format numbers on a report in 2007

[xp]

Using Office 2007:

2007 is throwing me here and I can't remember how to accomplish this easy
task...in a report based on a table, I want some values to appear using the
following format:

"#,##0.00_);[Red](#,##0.00)"

Can someone please throw me a bone and help me remember how to get this
done? I opened the properties for the field on the report but the "Format"
drop down is empty...also I'm fine using VBA - any solution appreciated.

 

[John Spencer MVP]

I think the color goes after the format definition (if I recall correctly).
Try the following and see if it works.

#,##0.00_;(#,##0.00)[Red]

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[xp]

Okay; never mind; I figured out what was happening; when I added a format to
the record source, it was giving a circular error because the "name" and the
"record source" had the same name...so renamed the "name" and problem
solved...

 

[xp]

Hi John, my problem is solved, but without the color...I tried both your
method and mine and everything works EXCEPT the color...if you come up with a
solution for that, please let me know...!

Thanks!

I think the color goes after the format definition (if I recall correctly).
Try the following and see if it works.

#,##0.00_;(#,##0.00)[Red]

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Using Office 2007:

2007 is throwing me here and I can't remember how to accomplish this easy
task...in a report based on a table, I want some values to appear using the
following format:

"#,##0.00_);[Red](#,##0.00)"

Can someone please throw me a bone and help me remember how to get this
done? I opened the properties for the field on the report but the "Format"
drop down is empty...also I'm fine using VBA - any solution appreciated.

 

[Marshall Barton]

Using Office 2007:

2007 is throwing me here and I can't remember how to accomplish this easy
task...in a report based on a table, I want some values to appear using the
following format:

"#,##0.00_);[Red](#,##0.00)"

Can someone please throw me a bone and help me remember how to get this
done? I opened the properties for the field on the report but the "Format"
drop down is empty...also I'm fine using VBA - any solution appreciated.

You should be able to just type:
#,##0.00_);[Red](#,##0.00)
into the text box's Format property.

I don't understand why you want the _) in there and suggest
that you remove it.

 

[xp]

Hi,

I work in Excel a lot and that "_)" adds a gutter space at the end so that
the values line up correctly when parentheses surround negative values...

In any case, I took the "_)" out and still no color on screen...any other
ideas? Or will the color not display, but print only? I want it to display on
screen in red...?

Thanks!

Using Office 2007:

2007 is throwing me here and I can't remember how to accomplish this easy
task...in a report based on a table, I want some values to appear using the
following format:

"#,##0.00_);[Red](#,##0.00)"

Can someone please throw me a bone and help me remember how to get this
done? I opened the properties for the field on the report but the "Format"
drop down is empty...also I'm fine using VBA - any solution appreciated.

You should be able to just type:
#,##0.00_);[Red](#,##0.00)
into the text box's Format property.

I don't understand why you want the _) in there and suggest
that you remove it.

 

[Marshall Barton]

I work in Excel a lot and that "_)" adds a gutter space at the end so that
the values line up correctly when parentheses surround negative values...

In any case, I took the "_)" out and still no color on screen...any other
ideas? Or will the color not display, but print only? I want it to display on
screen in red...?

You color specification is fine. Look elsewhere for some
other problem.

I think Access adds the extra space after a number
automatically when the negative format is enclosed in ( )