Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: dmyers on January 13, 2010, 11:23:50 PM

Title: Problem with Display Values
Post by: dmyers on January 13, 2010, 11:23:50 PM
I am trying to develop an equation within the Shapesheet that uses the Width property from another shape as an input, ie: "Sheet.279!Width / 5".  The problem I am having is that when I reference the Width of the other shape it adds a PT to the end of the number (ie: 12 PT. and what I want is 12).  Is there any way to tell Visio to remove the PT.?

Thanks
Title: Re: Problem with Display Values
Post by: wapperdude on January 14, 2010, 01:50:27 AM
Try using the format statement, http://msdn.microsoft.com/en-us/library/ms406694.aspx

For example, FORMAT(Sheet.279!Width / 5,"#.# ").  Actual example of using this may be found here:  Drawing Scale Symbol: a smartshape  (http://visguy.com/vgforum/index.php?topic=962.0 (http://visguy.com/vgforum/index.php?topic=962.0))

HTH
Wapperdude
Title: Re: Problem with Display Values
Post by: dmyers on January 14, 2010, 02:05:35 PM
Thanks for the reply.  I just tried out the FORMAT command and it is giving me the result I was looking for.

Thanks