number format on chart linked to Access

[nick]

I have a chart linked to an Access database. The link worked fine and I can
see all the field values that I want. The problem is that when I insert the
field into the shapes the number format does not contain any commas, so
instead of getting 42,153 the value is 42153. I can't figure out how, if
possible, to get to a formatt that will allow the commas to be displayed in
the shape when I insert it.

 

[Chris Roth [MVP]]

You can open the ShapeSheet for the shape, and scroll way down to the Text
Fields section.

In the format cells, you can enter something like:

="###,###,###.####"

to steer the formatting of the numbers. # is a placeholder for digits --
only when they exist. The only problem is if you work internationally where
decimal and comma are reversed (ie: in germany...)

--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/

 

[nick]

That worked. I can't express how much I appreciate this. Thanks.