2.2.4.13 ST_Format

Target namespace: http://schemas.microsoft.com/office/accessservices/2010/12/application

Referenced by: Format

Specifies the format type for displaying the data in a column. The actual formatting is implementation-specific.

Value	Meaning
General Number	Column data is a number formatted with the most compact of either fixed-point or scientific notation.
Currency	Column data is a currency value formatted with a currency symbol.
Fixed	Column data is a number, formatted with integral and decimal digits with optional negative sign.
Standard	Column data is a number formatted with integral and decimal digits, group separators, and a decimal separator with optional negative sign.
Percent	Column data is a number formatted as the number multiplied by 100 and displayed with a percent symbol.
General Date	Column data is a date that optionally includes a time.
Long Date	Column data is a long-form date.
Short Date	Column data is a short-form date.
Long Time	Column data is a long-form time.
Short Time	Column data is a short-form time.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this simple type.

 <xsd:simpleType name="ST_Format" wbld:cname="ST_Format">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="General Number" wbld:cname="GeneralNumber"/>
     <xsd:enumeration value="Currency" wbld:cname="Currency"/>
     <xsd:enumeration value="Fixed" wbld:cname="Fixed"/>
     <xsd:enumeration value="Standard" wbld:cname="Standard"/>
     <xsd:enumeration value="Percent" wbld:cname="Percent"/>
     <xsd:enumeration value="General Date" wbld:cname="GeneralDate"/>
     <xsd:enumeration value="Long Date" wbld:cname="LongDate"/>
     <xsd:enumeration value="Short Date" wbld:cname="ShortDate"/>
     <xsd:enumeration value="Long Time" wbld:cname="LongTime"/>
     <xsd:enumeration value="Short Time" wbld:cname="ShortTime"/>
   </xsd:restriction>
 </xsd:simpleType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).