Format numbers on a report in 2007

  • Thread starter Thread starter xp
  • Start date Start date
X

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.
 
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
 
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...
 
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!

John Spencer MVP said:
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.
Click to expand...
Click to expand...
 
xp said:
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.
Click to expand...

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.
 
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!



Marshall Barton said:
xp said:
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.
Click to expand...

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.
Click to expand...
 
xp said:
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...?
Click to expand...


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 ( )
 
Back
Top