I have been trying to compile a list of the various Format codes Visio uses for information. I have created a sampler shape that shows a variety of what I have found. I have found that the documentation on Visio Format codes has gaps. These are some of mysteries into.
Mystery 1. Predefined Format Codes
The only reference to Predefined Formats is in visio/about-format-pictures as a Note.
Note:
To define a date or time format picture by using Microsoft Office system formatting, enclose the format picture in double curly braces , for example, “{{m/d/yy}}”. If you are using a predefined format, for example, 201, enclose it in curly braces and angle brackets, like this: “{<201>}”
To define a date or time format picture by using Microsoft Office system formatting, enclose the format picture in double curly braces , for example, “{{m/d/yy}}”. If you are using a predefined format, for example, 201, enclose it in curly braces and angle brackets, like this: “{<201>}”
There are enumerations here visio.visfieldformats. It is strange that Visio heavily uses enumerations in SRC, but for Predefined Formats, you have to use the enumeration value rather than the enumeration.
Mystery 2. Curly and angled brackets?
Is there documentation about the curly and angled brackets other than in Mystery 1?
Mystery 3. Ft & In vs ‘ & “
So, when does Visio use the abbreviations rather than the quotes? I think I have worked that out, but not with a high confidence level.
Okay, the solution I was following used User cells to divide the value into feet and inches and then append double and single quotes. Under the Data Format -Number is Feet and inches
that results in
in the shapesheet, but where is that Text Field Format documented?
There is https://docs.microsoft.com/en-us/office/vba/visio/concepts/about-units-of-measure-visio but that is ft and in, not feet-inch.
John… Visio MVP in x-aisle
JohnVisioMVP.ca
john Visio MVP 