Visio Shapesheet "TextField"Format and the "right" command

[keagan]

I have a cubicle id field of example: "0430-11000-034", but I only
want to display the last three digits for example "034" on any shape
there is a right command - right(3) which will display from starting
from the right (3 spaces.).. but won't work in the shapesheet area
with either [right(3)] brackets are wrong?
Any suggestions... I want to avoid having to do vba.
I want to place it in the shapesheet Text Fields "Format" for the
Prop.CubicleID.
Current Format value is FieldPicture(0)...

 

[John Goldsmith]

Hello Keagan,

Have you had a look in Help?

The Right function takes the string and then the number of characters. So
(from help):
RIGHT ("January 1, 2004", 4)

Returns the value 2004.

So in your case you might want to place the Right function in the Insert
Field/Custom Formula.

Best regards

John


John Goldsmith
www.visualSignals.co.uk